how to find the second highest salary from emp table?
Answer Posted / pankaj raj patel
select max(salary ) from emp table where sal<(select max
(salary)from emp table)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how tsql statements can be written and submitted to the database engine? : Transact sql
Why do we use sql constraints? Which constraints we can use while creating database in sql?
What is memory optimized?
What are transaction and its controls?
what is a database transaction? : Sql dba
What is sql injection owasp?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
What do you know by pl/sql cursors?
What is a left join?
What are sql built in functions?
how to create a test table in your mysql server? : Sql dba
What are the features of pl sql?
Explain the the update statement in sql?
What is join view in sql?
What is time based sql injection?