How to select or fetch 50% data from SQL table

 Below query is useful to select 50% data from SQL table:

Select top 50 percent * from Employee;

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