select max(sal) from employee where sal<(select max(sal) from employee)

how to find the second highest salary from emp table?

Question Posted / anurag kumar rai

Answer Posted / anurag kumar rai

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a trigger word?

964

What is nosql vs sql?

1123

Can we debug stored procedure?

959

How do I view a table in sql?

954

how to write date and time literals? : Sql dba

915

Can we create foreign key without primary key?

933

What is sqlservr exe?

943

What is pl sql in dbms?

902

How is debugging done?

921

Is primary key always clustered index?

947

How to use sql*plus built-in timers?

1097

What are the different sql languages?

986

explain advantages of myisam over innodb? : Sql dba

1017

What does plv msg allows you to do?

1075

What is trigger in pl sql?

959