how do we find every fifth record in a table
Answer Posted / satya gupt
select salary from emp e where 4=(select count(salary) from
emp where salary>e.salary
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What are various limitations of the views?
What does nvl stand for?
What are the types of subscriptions in SQL Server replication?
What are 3 ways to get a count of the number of records in a table?
Explain the ways to controlling cursor behavior?
What are dml (data manipulation language) statements in ms sql server?
How can delete duplicate records in cte in sql server?
What is self contained multi valued query?
How to convert numeric values to integers in ms sql server?
Difference between primary key and clustered index?
Write query to return all rows sql?
How to remove duplicate rows from table?
What program is used to store the data source file?
How do I find query history in sql server?
What do you mean by stored techniques? How would we use it?