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 you force a query to use a specific index?
What is the difference between clustered and non-clustered indexes in ms sql server?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
How to declare and use cursor variables?
How efficient you are in oracle and SQL server?
What are views in ms sql server?
Explain some stored procedure creating best practices or guidelines?
What is store procedure? How do they work?
What part does database design plays a role in performance of an sql server-based application?
Can you explain what is indexed view? How to create it?
what is difference between view and Dip.
What is sql server profiler?
Can you leave a union at any time?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?