Get alternate record from table
Question
TheDataMonk
Follow Me
About TheDataMonkGrand Master
I am the Co-Founder of The Data Monk. I have a total of 6+ years of analytics experience 3+ years at Mu Sigma 2 years at OYO 1 year and counting at The Data Monk I am an active trader and a logically sarcastic idiot :)Follow Me
Related questions
The Given Data set, Table has transitive dependencies. Explain Which Attributes are partially dependent. How will you overcome this? Explain the approach?
Write a query to Plot a Relationship between the highest followers in every country (Country Wise Highest Followers) and show which country has the highest followers and which country has the lowest one. Explain the approach?
Write a Query to Find the account with the highest number of followers in every country. Explain the approach?
Assign Rank To each Category by authentic engagement in each country and return the category with a rank less than 3. Explain the Approach?
Write a Query to check for Missing values in the given table? Explain how will you deal with the missing data for qualitative and quantitative data?
Answers ( 9 )
— To fetch even records
select * from tableA WHERE ID % 2 == 0
— To fetch odd number of records
select * from tableA WHERE ID % 2 != 0
Awesome
Select *
from (
Select * , row_number() OVER(order by empid desc ) As RowNumber from Employee) t
Where t.RowNumber % 2 == 0
Note: In case of odd records do
RowNumber % 2 == 1
*Assuming id is unique and auto-increment column*
Select id from table
where mod(id, 2) 0; –to fetch odd rows
Select id from table
where mod(id, 2) = 0; –to fetch even rows
1. To fetch Even records: select * from Table_Name WHERE ID % 2 == 0
2. To fetch Odd records: select * from Table_Name WHERE ID % 2 != 0
SELECT *
FROM (
SELECT *, Row_Number() OVER(ORDER BY id) AS RowNumber
FROM table
) t
WHERE t.RowNumber % 2 = 0
with cte as (select *,row_number() over ( order by empld desc) as r_num from employee_table)
select * from cte where r_num %2=0;
select * from cte where r_num%2!=0;
Assuming Table consists of ID/Sl.no which is AUTOINCREMENT and do not contain any NULL values
Select *from Table
where ID%2 ==0;
1. Assuming the table is ordered in increasing order of ID
SELECT * FROM table WHERE id%2=0
2. Assuming table is not ordered and i can order in increasing order of ID
WITH sub AS
(SELECT *,ROW_NUMBER() OVER (ORDER BY id ASC) AS r_nbr
FROM table)
SELECT * FROM sub WHERE r_nbr%2=0