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...

how do we find every fifth record in a table

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we use max in where clause?

935


What does the not null constraint do?

1103


What is the difference between for trigger and after trigger?

1116


Relational calculus is what type of language?

1042


what authentication modes does sql server support? : Sql server database administration

1119


What are different types of join?

1320


How is table type constraint applied to a table?

981


What is user defined stored procedures?

950


Define outer join?

1004


What is the maximum number of index per table?

1076


What program is used to store the data source file?

968


How to create a ddl trigger using "create trigger" statements?

1137


How check triggers in sql server?

998


as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

974


What is the difference between count and distinct count?

889