Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


how do we find every fifth record in a table

Answers were Sorted based on User's Feedback



how do we find every fifth record in a table..

Answer / krishans

SELECT RowNumber from ( Select ROW_NUMBER() OVER (order by
EmployeeID)as RowNumber
FROM Employee) as x
where x.RowNumber % 5 = 0

Is This Answer Correct ?    9 Yes 3 No

how do we find every fifth record in a table..

Answer / jahir

Select Top 1 * From (Select Top 5 * From Employee Order By
1 Asc) As X Order By 1 Desc

Is This Answer Correct ?    8 Yes 2 No

how do we find every fifth record in a table..

Answer / saravanan p

If we consider employee2 table having 16 records like

Name Salary
Ajith 10000
Arithas 2000
Balaji 20000
Gamesh 20000
Jith 23000
keerthy 14000
boopathy 21000
moorthy 12000
Muthu Krishnan 30000
Muthu Kumar 80000
naveen 10200
neerthy 40000
Raja 12000
Ramesh 12000
sangeeth 1100
Vairam 23000


With Temp as
(
select row_number() over(order by [name]) as 'rno',
[name] from employee2
)
select [name],salary from Temp
where rno%5 = 0


The result..

Name Salary
Jith 40000
Muthu Kumar 15000
sangeeth 50000

Is This Answer Correct ?    1 Yes 0 No

how do we find every fifth record in a table..

Answer / srivatsa p

Select Top 1 * From (Select Top 5 * From customers Order By
1 Asc) X Order By 1 Desc

Is This Answer Correct ?    4 Yes 4 No

how do we find every fifth record in a table..

Answer / saurabh tyagi

select id ,partcode from prt where id in
(

select case when row_number() over (order by partcode ) %
5 = 0
then row_number() over (order by
partcode)
else 0 end
from prt
)

Is This Answer Correct ?    0 Yes 0 No

how do we find every fifth record in a table..

Answer / divya mahendra sikarwar

Select Top 1 * From (Select Top 5 * From customer Order By
1 Desc) As X

Is This Answer Correct ?    2 Yes 2 No

how do we find every fifth record in a table..

Answer / vicky

Assuming there are 3 columns in the table emp1

select id, name ,salary from ( select id,name ,salary,
mod(rownum,5) as r from emp1) where r=0

Is This Answer Correct ?    0 Yes 0 No

how do we find every fifth record in a table..

Answer / shanmugam

with cte as(
select ROW_NUMBER() over (order by id) as serial,* from tablename
)
select * from cte where serial=5

Is This Answer Correct ?    0 Yes 0 No

how do we find every fifth record in a table..

Answer / avinash

SELECT employeeID from ( Select ROW_NUMBER() OVER ( order by id )as RowNumber,employeeID FROM Employee ) as x where x.RowNumber % 5 = 0

Is This Answer Correct ?    0 Yes 0 No

how do we find every fifth record in a table..

Answer / nataraj m

select * from employees where eid = (select max(eid) from
employees where eid in (select top 5 * from employees))

Is This Answer Correct ?    2 Yes 3 No

Post New Answer



More SQL Server Interview Questions

how to know Who Is Blocking Your SQL Server?

4 Answers  


difference between Clustered index and non clustered index ?

0 Answers   Infosys,


What is sql language?

0 Answers  


How will u find the query which is running in some other machine

4 Answers   CarrizalSoft Technologies, IBM,


What is always encrypted?

0 Answers  






How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

0 Answers  


How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

0 Answers  


What are ddl (data definition language) statements for tables in ms sql server?

0 Answers  


Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

0 Answers  


How many types of TRIGGERS are there in MS SQL Server?

8 Answers   CarrizalSoft Technologies, TCS, United Healthcare,


What is exporting and importing utility?

0 Answers  


Difference between Inner vs outer joins?

0 Answers  






Categories