Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361144 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 / amol
select MAX (sallary) from emp where sallary<=(select MAX(sallary) from emp)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the advantages of sql?
How to get help at the sql prompt?
How to display the current date in sql?
What do you understand by pl/sql records?
What is int identity in sql?
How to Declare Fixed Length String Value In PL SQL
Write a query to display the current date in sql?
explain the advantages and disadvantages of stored procedure? : Sql dba
Why left join is used in sql?
Explain the difference in execution of triggers and stored procedures?
What is the most restrictive isolation level? : Transact sql
What is sqlerrm?
Define implicit and explicit cursors.
Can we create index on primary key?
What is exception? What are the types of exceptions?
