Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /* 3a */
- select emp.ename, customer.name, sum(ord.total)
- from emp emp, customer customer, ord ord
- where emp.empno = customer.repid and ord.custid = customer.custid
- group by rollup(emp.ename, customer.name)
- order by emp.ename,customer.name;
- /* 3b */
- select nume_client, total, position from(
- 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