select salary from emp e where 4=(select count(salary) from emp where sal

how do we find every fifth record in a table

Question Posted / satya gupt

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

Please Help Members By Posting Answers For Below Questions

What are various limitations of the views?

1057

What does nvl stand for?

946

What are the types of subscriptions in SQL Server replication?

1043

What are 3 ways to get a count of the number of records in a table?

1080

Explain the ways to controlling cursor behavior?

922

What are dml (data manipulation language) statements in ms sql server?

989

How can delete duplicate records in cte in sql server?

970

What is self contained multi valued query?

1023

How to convert numeric values to integers in ms sql server?

1096

Difference between primary key and clustered index?

1014

Write query to return all rows sql?

1061

How to remove duplicate rows from table?

1253

What program is used to store the data source file?

968

How do I find query history in sql server?

948

What do you mean by stored techniques? How would we use it?

1040