Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367535 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 / harish
select max(sal) from
emp where sal <(select max(sal) from emp)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is meant by temporal data?
What is the maximum rows in csv?
How do I install microsoft sql?
Show code of a cursor for loop.
How do I save the results of sql query in a file?
What are the different types of constraints?
What are %type and %rowtype for?
How are functions and procedures called in PL/SQL?
Can we create foreign key without primary key?
Describe types of sql statements?
How do you explain an index?
What is plpgsql language?
Explain the insert into statements in sql?
when is the use of update_statistics command? : Sql dba
What is dml statement?
