select max(sal) from employees where salary

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

Question Posted / sachin

Answer Posted / sachin

select max(sal) from employees
where salary < (select max(sal) from employees);

Is This Answer Correct ?

19 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is procedure and function in sql?

949

Is inner join faster than left join?

1142

Why schema is used in sql?

1003

Is sql a backend?

978

how to convert numeric values to character strings? : Sql dba

1052

What is mutating error in pl sql?

978

What is pivot query?

1025

how many groups of data types? : Sql dba

990

Explain the components of sql?

1010

What is procedure explain with example?

910

Can we delete column in sql?

1043

what is meant by urlencode and urldocode? : Sql dba

1112

How do you truncate?

862

what is the difference between blob and text? : Sql dba

977

Is sql injection illegal?

979