how do we find every fifth record in a table
Answer Posted / vijaya
select * from employee where employeeID % 5=0
| Is This Answer Correct ? | 4 Yes | 13 No |
Post New Answer View All Answers
Can we use max in where clause?
How to convert a numeric expression from one data type to another?
Explain various On-Delete options in a DB table. Which is the default option?
Where cross join is used?
Find columns used in stored procedure?
What are audit control procedures?
What is the downside of using udf?
What is the security model used in sql server 2005?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
Explain about local stored procedure?
What are trace files?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
Equi join and non equi join is possible with sql server?
Explain the database you used in your final year project?
What are the disadvantages of primary key and foreign key in SQL?