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

how to find the second highest salary from emp table?

Question Posted / hari thorat

Answer Posted / hari thorat

select max(salary) from employee where salary <(select max(salary) from employee);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what tools available for managing mysql server? : Sql dba

1130

What is procedure and function in sql?

1045

What is the difference between a database and a relational database?

1155

What is a primary key example?

1001

How to select 10 records from a table?

1206

What is a record in a database?

1102

How can we make an if statement within a select statement?

1067

What is varchar used for?

1138

How can you save or place your msg in a table?

1039

Can I learn sql in a week?

1119

How to sort the rows in sql.

1121

Mention what does the hierarchical profiler does?

1138

Is sql difficult?

1227

How do I create a sql script?

1142

What is the maximum rows in csv?

977