Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373212 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 / vinay
select max(sal) from emp where rownum = 2;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do I edit a trigger in sql developer?
Which data type is a composite type?
What is foreign key and example?
how to extract a unit value from a date and time? : Sql dba
how to decrement dates by 1 in mysql? : Sql dba
How do sql databases work?
How can I see all tables in sql?
Can a key be both primary and foreign?
In what condition is it good to disable a trigger?
What does select * from mean in sql?
What are local and global Indexes and where they are useful.
What is trigger in flip flop?
What is a loop in sql?
What is sql*loader and what is it used for?
Enlist some predefined exceptions?
