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

How to create function without parameter in sql server?

0 Answers  

What command must you use to include the not null constraint after a table has already been created?

0 Answers  

Detail about the hardware which is supported by SQL server?

0 Answers  

CREATE a table from another table

2 Answers  

How can you see what type of locks used?

1 Answers  

What are the different types of locks in the database?

0 Answers  

What is stretch database in sql server?

0 Answers  

What is change data capture (cdc) in sql server 2008?

0 Answers  

How to use column default values in insert statements in ms sql server?

0 Answers  

What is meant by Active-Passive and Active-Active clustering setup?

0 Answers  

Can a table be moved to different filegroup?

0 Answers  

What is the recursive stored procedure in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories