Another way is:: SELECT sal FROM sal a WHERE n = ( SELECT count(*) FROM

how we can find nth max salary from an employe table by
using my sql?

Question Posted / jithu

Answer Posted / jithu

Another way is::

SELECT sal FROM sal a WHERE n = ( SELECT count(*) FROM sal
b WHERE b.sal < a.sal)

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is the latest mysql?

1004

How to get current MySQL version?

1151

Where is mysql installed on linux?

975

how we will Show selected records sorted in an ascending (asc) or descending (desc).

1034

What is csv?

1018

What is mysql and mysqli?

974

Why use mysql procedures?

1034

Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.

1066

What are mysql functions?

999

How to enter Characters as HEX Numbers?

1061

Is mysql from oracle?

1021

Where’s database data actually stored? Is there a way to see the files which are stored?

1034

What is sqlyog?

1085

How do I start mysql in linux?

960

How do I rename a table in mysql workbench?

1030