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 reco…