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

preview_player
Показать описание
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?

#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
  1. SRTechnologies Ravindra Reddy
  2. SQL
  3. NTILE
  4. TOP50%ROWS
  5. HALFROWS
  6. SUBQUERY
Рекомендации по теме
5 Basic SELECT 0:06:43

5 Basic SELECT Statement Queries in SQL

How to Write 0:01:40

How to Write Basic SQL Statements (SELECT, FROM)

SOLVE 5 SQL 0:05:02

SOLVE 5 SQL QUERIES IN 5 MINUTES (PART 1) | MASTER IN SQL | SQL INTERVIEW QUESTIONS

Learn how to 0:49:56

Learn how to write SQL Queries(Practice Complex SQL Queries)

Secret To Optimizing 0:05:57

Secret To Optimizing SQL Queries - Understand The SQL Execution Order

Learn Basic SQL 0:17:40

Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners 1/3

SQL Explained in 0:02:23

SQL Explained in 100 Seconds

SQL indexing best 0:04:08

SQL indexing best practices | How to make your database FASTER!

Basic SQL Query 0:10:06

Basic SQL Query Structure Explained for Beginners! | #datascience #dataanalytics #sqlbasics #sql

Fastest Way To 0:00:11

Fastest Way To Learn SQL

Writing your first 0:04:13

Writing your first SQL queries in SQL Server

Approach to Complex 0:08:33

Approach to Complex SQL Queries

Complex SQL Query 0:16:52

Complex SQL Query Breakdown Step By Step

you need to 0:24:25

you need to learn SQL RIGHT NOW!! (SQL Tutorial for Beginners)

Advanced SQL Tutorial 0:08:37

Advanced SQL Tutorial | Subqueries

Let Power Query 0:03:08

Let Power Query write your SQL for you!

Write down the 0:16:48

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

3 AI SQL 0:00:58

3 AI SQL Tools #sql #ai #dataanalytics

Complex SQL Query: 0:15:10

Complex SQL Query: Watch Me Write It

SQL Query Optimization 0:03:18

SQL Query Optimization - Tips for More Efficient Queries

Practice Writing SQL 0:54:41

Practice Writing SQL Queries using Real Dataset(Practice Complex SQL Queries)

Learn How to 0:16:01

Learn How to write SQL Queries

How to Approach 0:00:57

How to Approach a SQL Query Step by Step

How to do 0:08:20

How to do Subqueries in SQL with Examples

Комментарии
Автор

We can get the 50% or any % of records from table using other method
select * from emp where rownum<= (select count(*)*.5 from emp);
Here count(*) * followed by your % of records

manjunathamc-xn
Автор

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

ramukodama