Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368238 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 / chandu
select max(sal)from table name where sal<(select max sal
from table name)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the different tcl commands in sql?
What is set serveroutput on in pl sql?
How is sql used in oracle?
What pl/sql package consists of?
What is sql indexing?
Why do we need unique key in a table?
how do you control the max size of a heap table? : Sql dba
What is insert command in sql?
What is the use of double ampersand (&&) in sql queries? Give an example
What is break?
What are procedures used for?
What is the difference between the sql*loader and import utilities? : aql loader
How to use transactions efficiently : transact sql
How do you select unique values in sql?
What is indexing in sql and its types?
