Ravi B

• Mar 30th, 2005

 

This is another simpler alternative: 
 
SELECT customer_no, payments FROM  
(SELECT customer_no, payments FROM  
customer C1 ORDER BY payments DESC) 
WHERE ROWNUM <4;

Manish Bhoge

• Apr 26th, 2005

 

select distinct payments  
from  
customer A 
where 5 >= ( 
select count(*) 
from customer B  
where A.payments ) 
order by payments descnull

Jasjeet Singh

• Aug 10th, 2005

 

select * from (select * from customer oder by payments asc) 
where rownum<4;

nileshsingh

 Profile Answers by nileshsingh 

• May 18th, 2006

 

select ename,sal from (select ename,sal from <table_name> order by sal desc ) where rownum <4

tsourabh

 Profile Answers by tsourabh 

• Jul 25th, 2007

 

 select * from customer where rownum < 4 order by payment desc ;

patilpravin_1981

 Profile Answers by patilpravin_1981 

• Jan 30th, 2008

 

select customer_id,payment from customer
having payment = (select max(payment) from customer)
where rownum < 3

g_sidhu

 Profile 

• Feb 6th, 2008

 

SELECT ROWNUM as RANK, Customer_no, paymentsFROM (SELECT Customer_no, payments
FROM customers ORDER BY payments DESC)WHERE ROWNUM <= 3;

patilpravin_1981

 Profile Answers by patilpravin_1981 

• Feb 7th, 2008

 

Select customer_no,max(payment) from customer
where rownum<4
group by customer_no;

ketansnadar

 Profile Answers by ketansnadar 

• Aug 18th, 2009

 

Situation 1 : 

If the payments and the customer no are having single records then use this 

SELECT top 3 * FROM Customer Order by Parments DESC

If the payments and the customer no are having more records and you want to sum up the payments and the retrieve then use this 

SELECT  TOP 3 [CustomerNo],SUM(Payments) FROM Customer group by [CustomerNo] order by sum(Payments) desc 

Rabindra_Kumar

 Profile Answers by Rabindra_Kumar 

• Oct 28th, 2009

 

SELECT * FROM (SELECT * FROM customer ORDER BY payment DESC)
WHERE rownum<=3

thirupathireddy

 Profile Answers by thirupathireddy Questions by thirupathireddy

• Feb 2nd, 2010

 

SELECT rownum, customer_no, payments FROM (SELECT customer_no, payments
FROM customer ORDER BY payments DESC)
WHERE rownum >3

thirupathireddy

 Profile Answers by thirupathireddy Questions by thirupathireddy

• Feb 2nd, 2010

 

SELECT rownum "rank", customer_no, payments FROM (SELECT customer_no, payments
FROM customer ORDER BY payments DESC)
WHERE rownum <4;

ankitagujrati28

 Profile Answers by ankitagujrati28 

• May 3rd, 2010

 

select rownum,cust_no,payments
from (select cust_no,payments from customer
where rownum<4
order by payments desc);