How to Select or Fetch 50% Data from SQL Table

The below query is useful for selecting 50% of the data from the SQL table.

SELECT TOP 50 PERCENT * FROM Employee;

This query will show 50% data from total table records. This is mostly asked interview questions.