how do we find every fifth record in a table
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 delete duplicate rows from table except one?
Is INSTEAD OF trigger directly applicable to Table ?
Explain different types of self contained sub query?
How to query multiple tables jointly?
Is there any difference between primary key and unique with the not null condition?
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
What do you mean by tablesample?
Write an sql query to find first weekday of the month?
how you can list all the tables in a database?
How to get @@error and @@rowcount at the same time?
How do I find my localdb version?
What are the differences between triggers and stored procedures?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
Explain the dbcc pintable command when would you use it?
How to create nested stored procedure?