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

Explain Geography datatype in SQL Server

1064

Explain differences between web edition and business edition?

119

When would you use the stored procedures or functions?

950

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

979

How sql server enhances scalability of the database system?

1114

What is the correct order of the logical query processing phases?

876

Find first and last day of current month in sql server

978

What is the purpose of sql profiler in sql server?

962

What do you know about normalization and de- normalization?

871

List out different types of normalizations in sql server and explain each of them?

888

What is your recommendation for a query running very slow? : sql server database administration

995

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

951

What is a non equi join?

916

Where can you add custom error messages to sql server?

1055

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

936