select sal from emp where limit,1 order by sal desc

how to find the second highest salary from emp table?

Question Posted / ved

Answer Posted / ved

select sal from emp
where limit,1
order by sal desc

Is This Answer Correct ?

12 Yes

20 No

Please Help Members By Posting Answers For Below Questions

What are some predefined exceptions in pl/sql?

1226

What is nosql db?

1020

How we can update the view?

1099

What is difference sql and mysql?

1038

how to create a new table by selecting rows from another table in mysql? : Sql dba

1168

What is Difference Between Unique and Primary Key Constraints?

1155

how to escape special characters in sql statements? : Sql dba

1083

What is group by in sql?

1128

How to add a column ‘salary’ to a table employee_details?

1052

How do I find duplicates in sql?

983

What are the indexing methods?

1099

what is dbms? : Sql dba

1036

What is use of trigger?

989

what is single byte over head in oracle..?

2458

what is 'mysqlcheck'? : Sql dba

1067