Interested to Buy Any Domain ? << Click Here >> for more details...
how to get second highest salary in SQL(as/4000
- 29 Answers
- 31174 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / devi
select sal from (select sal,rank() over(order by sal desc)
as rank from emp) where rank>1 and rank<3
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is nosql vs sql?
What operators deal with null?
what is a cursor? : Sql dba
What are actual parameters and formal parameters?
What is sqlcontext?
What is an example of translating a date into julian format?
What are different sql data types?
Name the different types of indexes in sql and define them.
What is over () in sql?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
The select into statement is most often used to create backup copies of tables or for archiving records?
What is snowflake sql?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
Is it possible to pass parameters to triggers?
Can we create index on primary key?
