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

Do you know what are the differences between lost updates and uncommitted dependencies?

1141

How you can change the database name in SQL SERVER?

1251

What are the pre-defined functions in the sql server?

1185

Why the trigger fires multiple times in single login?

1281

How to bind a view to the schema of the underlying tables?

1047

How you can minimize the deadlock situation?

1083

What is the difference between commit and rollback?

991

What is SQL Azure?

107

what is a self join? : Sql server database administration

1123

What are data resources?

964

Explain concepts of analysis services?

1015

What is the maximum size of sql server database?

1063

What is the main difference between ‘between’ and ‘in’ condition operators?

1277

What is an indice?

1085

How many cores do I need for sql server 2016?

952