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

Can you load data into multiple tables at once? : aql loader

1066

how do you know the version of your mysql server? : Sql dba

1004

What is use of trigger?

933

What is the use of partition by in sql?

996

how can we destroy the cookie? : Sql dba

1012

What are tables and fields in the database?

1112

How do I send sql query results to excel?

1066

How will you distinguish a global variable with a local variable in pl/sql?

1154

What is difference between cursor and trigger?

1078

Can we use having without group by in sql?

983

What is sqlcommand?

1032

explain advantages of myisam over innodb? : Sql dba

1069

what are all the different types of indexes? : Sql dba

1048

What is sqlcontext?

1086

What does select top 1 do in sql?

1098