SELECT DISTINCT salary FROM employee ORDER BY salary DESC LIMIT(2,1)

how to check the 3rd max salary from an employee table?

Question Posted / neeraj79

Answer Posted / neeraj79

SELECT DISTINCT salary
FROM employee
ORDER BY salary DESC
LIMIT(2,1)

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Which one is better subquery or joins?

1120

What is a column in a table?

1191

What is trigger in sql? Explain

1046

what are the different index configurations a table can have? : Sql dba

1050

what is a record in a database ? : Sql dba

1105

What is the plv (pl/vision) package offers?

1116

What is the order of sql select?

1091

What are all different types of collation sensitivity?

1080

What is the maximum number of columns in sql table?

1232

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1178

Is delete faster than truncate?

1055

what are the differences between char and nchar? : Sql dba

1163

Define concurrency control. : Transact sql

1236

how to use regular expression in pattern match conditions? : Sql dba

1089

What sql does db2 use?

1030