how to find the second highest salary from emp table?
Answer Posted / teja
select max(sal) from emp where empsal<(selelect max(sal)
from emp)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the stuff function and how does it differ from the replace function? : Sql dba
What mean sql?
Does sql*plus have a pl/sql engine?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
how tsql statements can be written and submitted to the database engine? : Transact sql
If a cursor is open, how can we find in a pl/sql block?
What jobs use sql?
What will you get by the cursor attribute sql%rowcount?
What are the topics in pl sql?
What is the non-clustered index in sql?
What are the differences between implicit and explicit cursors?
Explain spool.
How is data stored on a disk?
What are sql triggers used for?
Are sql database names case sensitive?