Write a query which return 5 p

Apple Interview Question for Developer Program Engineers

Email me when people comment.

An error occurred in subscribing you.

Email me when people comment.

An error occurred in subscribing you.

Comment hidden because of low score. Click to expand.

of 2 vote

SELECT customer_id, sum(expenses) as sexpenses
FROM customer
GROUP BY customer_id
ORDER BY sexpenses
LIMIT 5;

- Anonymous April 08, 2012 | Flag Reply

Comment hidden because of low score. Click to expand.

of 1 vote

Select distinct (custid) from (custid,sum(expenses) as S from T order by S desc) and rownum<=5

- codemonkey March 21, 2012 | Flag Reply

Comment hidden because of low score. Click to expand.

of 0 vote

select * from CUSTOMER C1 where (select count(*) from CUSTOMER C2 where C2.expenses > C1.expenses )<5 order by C1.expenses DESC;

- Logan November 24, 2010 | Flag Reply

Comment hidden because of low score. Click to expand.

of 0 vote

select TOP 5 customer_id,sum(expenses) spend
from customer
group by customer_id

- Anonymous December 23, 2010 | Flag Reply

Comment hidden because of low score. Click to expand.

of 0 votes

select TOP 5 customer_id,sum(expenses) spend
from customer
group by customer_id
Order by sum(expenses) DESC

- Anonymous December 23, 2010 | Flag

Comment hidden because of low score. Click to expand.

of 0 votes

SELECT ename, sal 
  FROM ( SELECT ename, sal, RANK() OVER (ORDER BY sal DESC) sal_rank
           FROM emp ) 
 WHERE sal_rank <= 5;

- AG September 14, 2011 | Flag

Comment hidden because of low score. Click to expand.

of 0 vote

select top 5 customerid, SUM(expenses) from samples group by CustomerId order by SUM(expenses) desc

- NIRAJ November 30, 2012 | Flag Reply

Comment hidden because of low score. Click to expand.

of 0 vote

Select cust_id,prod_id,SUM(expenses) as expenses from cust group by cust_id order by expenses desc limit 5;

- Anonymous September 04, 2013 | Flag Reply