Interested to Buy Any Domain ? << Click Here >> for more details...
how do we find every fifth record in a table
- 14 Answers
- 18753 Views
- Aspire, HCL, I also Faced
- E-Mail Answers
Answer Posted / vicky
Assuming there are 3 columns in the table emp1
select id, name ,salary from ( select id,name ,salary,
mod(rownum,5) as r from emp1) where r=0
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to add additional conditions in SQL?
What is Transparent Data Encryption?
What is the difference between for trigger and after trigger?
What do you understand by the data quality services in sql server?
Explain query editor regions
How to write a query with a right outer join in ms sql server?
What is the difference between a check constraint and a rule?
How does clustered and non clustered index work?
List the advantages of using stored procedures?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
What is difference between standardization and normalization?
Tell me what is use of except clause? How it differs from not in clause?
How to delete exactly duplicate records from a table?
What are character string data types in ms sql server?
List the data types available in mssql?
