Write down the SQL Query to fetch 50% rows from total records?

Hi Guys
As part of SQL Interview Question Series I have explained below question.
Write down the SQL Query to fetch 50% rows from total records?
github link for SQL Code for practice: github.com/ram...
#ntile #pyhon #etl #etltesting #sql #operator #operatorsinjava #interview #oracle #job #dwh #informatica #it #sql_server #db2 #postgres #postgresql #teradata #mysql #hive #hdfs #data #dataengineeringessentials #dataengineering #dataengineer #dataanalytics #datascience #dataanalysis #odd #evenrecords #dataengineer #java #pyhon#sql #sql_server #postgresql #postgres #dataanalytics #hdfs #sql #development #pyhon #dwh #plsql #db2 #dataengineer #teradata #dataengineer #mssqlserver #msdhoni #msexcel #interview #interviewquestions #views #subquery #inlineview #businessanalystcourse #businessanalyst #sybase #postgres #mssqlserver

[@user-kl9ot3ko5p]

We can get the 50% or any % of records from table using other method
select * from emp where rownum

[@musakoroma4649]

U good

[@sumadhanapal6589]

very useful sir, thank you

[@srtechnologiesravindraredd5303]

Your welcome.. Please share with others as well

[@ramukodama5501]

My Question in this scenario Salary in ascending order in the input due that reason, your query work, if the salary in random order how you fetch 50% of the records

[@ashokmanju4354]

What u say is well understood sir

[@srtechnologiesravindraredd5303]

Thanks for your response and please try to share with others as well...