how to find the second highest salary from emp table?
Answer Posted / parvezkhan pathan
select max(salary) from emp where salary not in(select
max(salary) from emp);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can you have more than one trigger on a table?
What do you mean by stored procedures? How do we use it?
Are there any features that are decommissioned in 11g that are not present in 11g?
What is user defined functions?
Is a table valued function object?
How can one get sql*loader to commit only at the end of the load file? : aql loader
define sql insert statement ? : Sql dba
how to include numeric values in sql statements? : Sql dba
How do I start sql profiler?
How do I debug a stored procedure?
What does over partition by mean in sql?
What are sql triggers used for?
What do you mean by stored procedures?
What is a common use of group by in sql?
how to start mysql server? : Sql dba