Home » SQL & PL/SQL » SQL & PL/SQL » SQL query needed
SQL query needed [message #251036] Thu, 12 July 2007 04:23 Go to next message
Messages: 1
Registered: July 2007
Location: singapore
Junior Member

Hi Guys,

my current query :
SELECT * FROM pid WHERE ppn='77I-00000' AND serial_num IS NULL AND ROWNUM <=20 ORDER BY seq

as i facing some issue using row num. i need to fetch top 20 rows based on "seq" column and without using rownum property.

its very urgent, coz my application is on testing.

Thanks in advance,
Re: SQL query needed [message #251039 is a reply to message #251036] Thu, 12 July 2007 04:27 Go to previous message
Michel Cadot
Messages: 65137
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Nothing is urgent in a forum
2/ Except for you to search before posting
3/ And also to read the stickies
4/ Now search the answer is already there.

Previous Topic: deferrable foreign key
Next Topic: an interesting query
Goto Forum:

Current Time: Thu Aug 17 01:09:58 CDT 2017

Total time taken to generate the page: 0.06599 seconds