Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

how do we find every fifth record in a table

Question Posted / waqar

Answers were Sorted based on User's Feedback



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

Answer / satya gupt

select salary from emp e where 4=(select count(salary) from
emp where salary>e.salary

Is This Answer Correct ?    1 Yes 4 No

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

Answer / kumar.t

Table Name Is Employee
EmployeeId Is Identity field

Select * From Employee Where EmployeeId In (Select
EmployeeId From Employee Where EmployeeId%5=0)

by
Kumar.T

Is This Answer Correct ?    1 Yes 4 No

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

Answer / santhi k

Using Top N analysis....


select * from (select rownum rn, col1,col2,col3 from
tablename) where mod(rn,5)=0;

Is This Answer Correct ?    1 Yes 7 No

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

Answer / vijaya

select * from employee where employeeID % 5=0

Is This Answer Correct ?    4 Yes 13 No

Post New Answer

More SQL Server Interview Questions

What is an entity-relationship diagram (erd)?

0 Answers  

How to enter comments in transact-sql statements?

0 Answers  

How to make a remote connection in a database?

0 Answers  

How to provide Security for package?

1 Answers   Convergys,

i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.

3 Answers   iFlex,

How do I create a partition table in sql server?

0 Answers  

Explain Geography datatype in SQL Server

0 Answers   Infosys,

What is the query and subquery?

0 Answers  

How do I schedule a sql server profiler trace?

0 Answers  

What is master database? : SQL Server Architecture

0 Answers  

What is Self Join?

4 Answers  

What are trace flags?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories