Hi Dipti,

You can use the below querry to get the table names in your DB:

select * from tab;

If you are just interested in viewing the names and not the other info about tables, you can use

select * from tab

Yes buddy, the extra sub querry is needed, as in below case :

select * from <tab> where rownum <=5
order by <a> desc

the first 5 rown are getting sorted and then ordered, which would not...

Got the soln, as below

select * from (select a from <tbl> order by a DESC) where rownum<=5;

Thanks.

Hi ,

Can we have an sql query to get the max 5 values from a column?
Please paste a sample code if its possible.

Thanks in advance.