Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368189 Views
- CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
- E-Mail Answers
Answer Posted / sarojkant
select sal from emp
where rownum=2
order by sal desc
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I clear the screen in sql plus?
Which kind of parameters cannot have a default value in pl sql?
Why do we use triggers?
How many sectors are in a partition?
What are the different types of a subquery?
Cite the differences between execution of triggers and stored procedures?
how to see the create table statement of an existing table? : Sql dba
What is error ora-01000: maximum open cursors exceeded
What do you mean by query optimization?
Is sql a dbms?
What is a dirty read sql?
What is %type in sql?
What is the difference between nested table and varray?
What are the types of queries in sql?
What is the difference between sum and count in sql?
