how to get second highest salary in SQL(as/4000
- 29 Answers
- 27017 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
Is it mandatory for the primary key to be given a value when a new record is inserted?
How do I copy a table in sql?
Can a key be both primary and foreign?
What are aggregate functions in sql?
how to get a list of columns in an existing table? : Sql dba
Why trigger is used in sql?
What language is oracle sql developer?
Can we rollback after truncate?
Does sql between include endpoints?
Is it possible to create startup or shutdown trigger for on-schema?
How much does sql certification cost?
how does a local variable is defined using t-sql? : Transact sql
Why partition by is used in sql?
Differentiate between % rowtype and type record.
What are the triggers associated with image items?
