how to find the second highest salary from emp table?
Answer Posted / gayathri
select max(salary ) from emp table where sal<(select max
(salary)from emp table)
Is This Answer Correct ? | 754 Yes | 97 No |
Post New Answer View All Answers
how to run 'mysql' commands from a batch file? : Sql dba
Can there be more than one function with a similar name in a pl/sql block?
What is data abstraction in sql?
What is the life of an sql statement?
How many sectors are in a partition?
Why we use sql profiler?
how to shut down the server with 'mysqladmin'? : Sql dba
What is crud stand for?
explain normalization concept? : Sql dba
what is the syntax for using sql_variant_property? : Transact sql
What is sql catalog?
Explian rowid, rownum?
what are the differences between binary and varbinary? : Sql dba
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
Explain about various levels of constraint.