Select Emp_Name from emp_table where Id=(Select Emp

how to find the second highest salary from emp table?

Question Posted / bharath konegadde

Answer Posted / bharath konegadde

Select Emp_Name from emp_table where Id=(Select Emp_Id from Salary Order By salary Desc limit 0,1)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is compilation error in pl sql?

920

How many types of cursors supported in pl/sql?

1095

What are the different operators available in sql?

963

What program will open a mdb file?

915

What are different types of sql commands?

1026

What is your daily office routine?

2220

What are the types of sql commands?

1020

what is self join and what is the requirement of self join? : Sql dba

1078

What is dcl in sql?

907

What does rownum mean in sql?

953

What are the different dml commands in sql?

1090

what are sequences

1622

What is bulk compiling in pl/sql.?

1065

does sql support programming? : Sql dba

992

what is an extent ? : Sql dba

1021