Write down the SQL Query to fetch 50% rows from total records?
HTML-код
- Опубликовано: 6 сен 2024
- 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
We can get the 50% or any % of records from table using other method
select * from emp where rownum
U good
very useful sir, thank you
Your welcome.. Please share with others as well
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
What u say is well understood sir
Thanks for your response and please try to share with others as well...