Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367836 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 / hari chaudhary
All My friend use this query then good result of your sql
database find in second or Third last data find.....
Select distinct(salary) From employee E1 Where
(n-1) = (Select Count(Distinct(E2.salary)) From employee E2
Where E2.salary > E1.salary)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is transaction control language (tcl)?
Which certification is best for sql?
How to assign sql query results to pl sql variables?
What is native sql query?
define data blocks ? : Sql dba
What are the main features of cursor?
What is difference between joins and union?
What is error ora-12154: tns:could not resolve the connect identifier specified?
what are myisam tables? : Sql dba
How many types of relationship are there?
what are date and time functions in mysql? : Sql dba
Does group by remove duplicates?
What is autocommit sql?
What is a field in a database?
How many indexes can be created on a table in sql?
