Sergey Mois

Try this



maybe this will help: http://www.sql-tutorial.ru/en/book_using_multiple_tables_in_query.html

Paging in SQL Server

select sum(e1.salary), e1.departmentid from employee e1 group by e1.departmentid having sum(e1.salary) >= ALL(select sum(e1.salary) from employee e1 group by e1.departmentid)

You can use SQL Exercises to prepare for certification.

Try certification on SQL Exercises