Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368644 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 / radha sri seshu.kolla
select max(sal) from emp where level=2 connect by prior
sal>sal group by level;
| Is This Answer Correct ? | 17 Yes | 22 No |
Post New Answer View All Answers
Can dml statements be used in pl/sql?
What does closing a cursor do?
How do I filter in sql profiler?
Does sql support programming?
what is not null constraint? : Sql dba
What is java sql package?
How does an execution block start and end in pl sql?
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
Is sql port 1433 encrypted?
Show how functions and procedures are called in a pl/sql block.
What is data types in sql?
Why is sql better than hql?
Can function return multiple values in sql?
what is the difference between sql and t-sql? : Transact sql
Can we rollback truncate?
