Select first half record from table in SQL server

In SQL Server, the SELECT TOP clause is used to specify the number of records to return.

It can be very useful on large tables with thousands of records. You can use the TOP clause to limit the number of rows that are returned in the result set. It’s returning a large number of records can impact on performance. 

Following these are steps to select first half records from table in SQL server.

Step1  Firstly create a table with some records in sql server 

Step2  Write sql query for select half records

select top 50 percent * from tbl_products