Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373265 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 / ramcharan tej
select max(emp-sal) from emp
where emp-sal <(select max(emp-sal) from emp).
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do I debug a stored procedure?
What is time based sql injection?
What is scope of pl sql developer in future?
What is the difference between Union and Union all. Which is faster.
What are the ways on commenting in a pl/sql code?
How to change the order of columns in Oracle SQL Plus ?
Why are aggregate functions called so?
Is natural join same as inner join?
How to run sql statements with oracle sql developer?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
What is the difference between a database and a relational database?
how can you create an empty table from an existing table? : Sql dba
What is the mutating table and constraining table?
What are the possible values that can be stored in a boolean data field?
Show code of a cursor for loop.
