Wednesday, 11 September 2013

5. Display a report that contains the employee ID, login ID, and the title of employees. The report should display the records for 10 employees after excluding the records of the first five employees. (Use the AdventureWorks database)

select * from HumanResources.Employee
select EmployeeID,LoginID,Title from HumanResources.Employee
order by EmployeeID
OFFSET 5 Rows
fetch next 10 Rows only

No comments:

Post a Comment