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

How to install oracle sql developer?

1050

What is the clause we need to add in function body to return variable?

1013

what happens if you no create privilege in a database? : Sql dba

1002

what is data manipulation language? : Sql dba

1022

How many triggers can be applied on a table?

935

how to write date and time literals? : Sql dba

964

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1167

Why is sql*loader direct path so fast?

1108

How can I speed up sql query?

966

What is pl sql collection?

975

How do you drop a trigger?

996

How do I remove duplicates in two columns?

1073

Is oracle sql free?

991

What is sql prepared statement?

989

Can you inner join the same table?

995