To get four top most records from a table [message #402072] |
Thu, 07 May 2009 08:47  |
raghu.iv85
Messages: 13 Registered: December 2008 Location: banglore
|
Junior Member |
|
|
Hi all,
I have one view named 'dshb_mcr_glob_we_time_v3'. In this view, I have 'perd_id' column. This column datatype is number. I want to get top four ids as a output. Can anyone please send me the query for that?
Thanks & Regards,
Raghu.
|
|
|
|
|
|
|
|
Re: To get four top most records from a table [message #402192 is a reply to message #402177] |
Fri, 08 May 2009 01:02  |
 |
Michel Cadot
Messages: 68737 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
With rn<=3 I doubt you get 4 rows.
Once again, your post don't add anything to previous ones but errors.
First give clue (but this one has already been given)
Then, if OP shows what he tried and couldn't get it, post a solution, a tested solution, a working solution.
But do not be rude agains others ignoring their posts.
Regards
Michel
|
|
|