how to find the second highest salary from emp table?
- 211 Answers
- 321948 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 / jayshree
select max(sal) from table_name where sal not in (select
max(sal) from table_name)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
What view means?
Is primary key always clustered index?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What is multiple partition?
Why select is used in sql?
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
Do foreign keys improve performance?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
Why do we use triggers?
What is the difference among union, minus and intersect?
Can we write ddl statements in functions?
What is time based sql injection?
Is primary key an index?
how can I make a script that can be bi-language (supports english, german)? : Sql dba
