Wednesday, 19 October 2016

Get all records of a table by using TOP in select statement

As usual we use TOP keyword in our SQL statement for retrieving few records, but you can use TOP keyword to retrieve all data of a table by using "TOP 100 PERCENT" in your SQL statement.
SELECT TOP 100 PERCENT * FROM dbo.[EmployeeDetail]
Visit Our New Site for HR Interview Questions Answers
Sponsored Ads


Post a Comment