select sal from employee order by sal desc limit 1,1; its 100% true i ha

how to get second highest salary in SQL(as/4000

Question Posted / praveen agrawal

Answer Posted / praveen agrawal

select sal from employee order by sal desc limit 1,1;

its 100% true i have checked it out.

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is user in sql?

1077

what are the limitations of identity column? : Transact sql

1162

what are the different tables present in mysql? : Sql dba

1042

What are the features of pl sql?

1111

How do I find duplicates in two columns?

1265

Can we use ddl commands in pl sql?

1234

Is postgresql a server?

1113

What is record data type?

981

what is primary key? : Sql dba

1081

discuss about myisam key cache. : Sql dba

1070

What is embedded sql what are its advantages?

1108

Can we rollback truncate?

1050

Can we join more than 2 tables in sql?

1093

What is a sql profiler?

1066

How is a PL/SQL code compiled?

1283