Interested to Buy Any Domain ? << Click Here >> for more details...
how do we find every fifth record in a table
- 14 Answers
- 18759 Views
- Aspire, HCL, I also Faced
- E-Mail Answers
Answer Posted / vijaya
select * from employee where employeeID % 5=0
| Is This Answer Correct ? | 4 Yes | 13 No |
Post New Answer View All Answers
How to change the system date and time from SQL Plus Terminal ?
How to create stored procedures with parameters in ms sql server?
Explain foreign key in sql server?
What is difference between foreign key and unique key?
Explain in brief about Microsoft SQL server?
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
What are the underflow and overflow behaviors on float literals?
What is a scheduled job or what is a scheduled task?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
How to modify existing triggers using "alter trigger"?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What is the purpose of the master database?
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
Explain what is row_number function?
