Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361432 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 / jithu
SELECT MAX(SALARY) FROM EMPLOYEE WHERE SALARY NOT IN
(SELECT MAX(SALARY) FROM EMPLOYEE)
| Is This Answer Correct ? | 9 Yes | 8 No |
Post New Answer View All Answers
How can you fetch first 5 characters of the string?
what are the differences between char and nchar? : Sql dba
How many sql statements are used? Define them.
What is int identity in sql?
What are data types in pl sql?
Can we have two clustered index on a table?
What is java sql drivermanager?
Name the operator which is used in the query for pattern matching?
What are the most important ddl statements in sql?
Why we use pl sql?
Which is better join or subquery?
What is trigger in flip flop?
What is flag in sql?
What is a record in a database?
How we can update the view?
