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

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

very useful sir, thank you

What u say is well understood sir