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
Can we use max in where clause?
What does the not null constraint do?
What is the difference between for trigger and after trigger?
Relational calculus is what type of language?
what authentication modes does sql server support? : Sql server database administration
What are different types of join?
How is table type constraint applied to a table?
What is user defined stored procedures?
Define outer join?
What is the maximum number of index per table?
What program is used to store the data source file?
How to create a ddl trigger using "create trigger" statements?
How check triggers in sql server?
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
What is the difference between count and distinct count?