how do we find every fifth record in a table
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
How to select an exiting database using mssql_select_db()?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
what is the maximum size of a row? : Sql server database administration
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
Explain about SQL server 2005?
Explain sql server service broker?
What is sparse columns of sql server 2008?
How to start and end transact-sql statements?
If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?
What is the difference between primary key and unique constraints?
Explain “@@rowcount” and “@@error” in sql server?
Do you know what is lock escalation?