Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 372953 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 / abhay
select max(sal) from emp where sal< (select max(sal) from
emp)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Explain cursor types?
How do I copy a table in sql?
How do you update sql?
What is an escape character in sql?
What is query optimization in sql?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
What is the use of procedures?
What is a sql trace file?
How to add, remove, modify users using sql?
Why is sharding used?
what is a constraint? Tell me about its various levels. : Sql dba
Which language is used in sql?
What is data control language?
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
Can we use two order by clause in query?
