Advertisement
Guest User

Untitled

a guest
Apr 26th, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. /* 3a */
  2. select emp.ename, customer.name, sum(ord.total)
  3. from emp emp, customer customer, ord ord
  4. where emp.empno = customer.repid and ord.custid = customer.custid
  5. group by rollup(emp.ename, customer.name)
  6. order by emp.ename,customer.name;
  7.  
  8. /* 3b */
  9. select nume_client, total, position from(
  10. select nume_client, total, dense_rank() over (order by total asc) position from client1 )where position between 1 and 3;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement