Ad:

Oracle Discussion Thread
Unsolved
Views: 3450

Page 1
2
Next

You are currently viewing page 1 of this multi-page discussion thread

Mar 27th, 2009

how to display only the first 3 rows

Expand Post »

Please how can I write a query to display only the top three earners in a table in desc order e.g
Emp Sal
John 100
Jam 120
Abi 90
Jo 170
the query should display
Emp Sal
John 200
Jam 170

thanks

Similar Threads

How do you only display 8 rows per page? PHP/MYSQL in PHP
Display morethan one coulmn from mysql database in PHP in PHP
display fix set of data in table.... in PHP
Compare subparts of a field over multiple rows in Oracle
Displaying Mysql rows, alternate colors? in PHP

achiman

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

51 posts
since Mar 2009

Permalink

Mar 27th, 2009

Re: how to display only the first 3 rows

I have tried using numrow but it doesnt do the job

achiman

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

51 posts
since Mar 2009

Permalink

Mar 27th, 2009

Re: how to display only the first 3 rows

please is there any function called rank in oracle and how can i use it

achiman

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

51 posts
since Mar 2009

Permalink

Mar 27th, 2009

Re: how to display only the first 3 rows

rank does not work maybe because im using oracle8i

achiman

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

51 posts
since Mar 2009

Permalink

Mar 30th, 2009

Re: how to display only the first 3 rows

Try this

sql Syntax (Toggle Plain Text)
SELECT * FROM emp WHERE rownum<4 ORDER BY sal desc
select * from emp where rownum<4 order by sal desc

debasisdas

Featured Poster

Reputation Points: 665

Solved Threads: 427

Posting Genius

Offline

6,406 posts
since Feb 2007

Permalink

May 31st, 2009

Re: how to display only the first 3 rows

ya what debasisdas wrote works for ur query

manuhar

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

11 posts
since May 2009

Permalink

Jun 18th, 2009

Re: how to display only the first 3 rows

Click to Expand / Collapse Quote originally posted by debasisdas ...

Try this
sql Syntax (Toggle Plain Text)
SELECT * FROM emp WHERE rownum<4 ORDER BY sal desc
select * from emp where rownum<4 order by sal desc

Hello,

Before solution is incorrect.

The good solution:

sql Syntax (Toggle Plain Text)
SELECT *
   FROM (SELECT *
                 FROM emp
               ORDER BY sal DESC)
 WHERE ROWNUM <= 3
SELECT *
   FROM (SELECT *
                 FROM emp
               ORDER BY sal DESC)
 WHERE ROWNUM <= 3

First step - Obtain the records with all fields in the correct order (view-inline)
Second step - Cut the records in the 3 (Top1-query)

Last edited by peter_budo; Jun 19th, 2009 at 1:05 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

anubina

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

17 posts
since Jun 2009

Permalink

Jul 14th, 2009

Re: how to display only the first 3 rows

I hope this query also may help:

Select top(3) from emp order by sal DESC

Kishor_12

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Jul 2009

Permalink

Jul 14th, 2009

Re: how to display only the first 3 rows

There is no Top in Oracle. That is SQL Server syntax.

cgyrob

Reputation Points: 91

Solved Threads: 18

Junior Poster

Offline

125 posts
since Sep 2008

Permalink

Jul 15th, 2009

Re: how to display only the first 3 rows

Click to Expand / Collapse Quote originally posted by Kishor_12 ...

I hope this query also may help:

Select top(3) from emp order by sal DESC

You need to read question properly before answering to them. This is oracle forum not sql server.

debasisdas

Featured Poster

Reputation Points: 665

Solved Threads: 427

Posting Genius

Offline

6,406 posts
since Feb 2007

Page 1
2
Next

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Oracle Forum Timeline: Find Oracle Tables that contain a specific field

Next Thread in Oracle Forum Timeline: problem.

DaniWeb Message

Cancel Changes

User Name
Password