Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373242 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 / kishor
select max(salary ) from employee
where
sal<(select max(salary)from employee)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the use of sql trace?
Why functions are used in sql?
How to make a copy values from one column to another in sql?
What is sql comments?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
What's the difference between inner join and left join?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
How do you bind variables in pl sql?
Does execute immediate commit?
What is a stored procedure in sql with example?
Is sql easier than java?
What are synonyms in sql?
What is varchar sql?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
what are the authentication modes in sql server? How can it be changed? : Sql dba
