Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368613 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 / pankaj kumar
SELECT filedname
FROM tablename
ORDER BY fieldname DESC
LIMIT 2 , 1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is optimistic concurrency control? : Transact sql
The in operator may be used if you know the exact value you want to return for at least one of the columns.
How many databases can sql express handle?
what is msql? : Sql dba
Is join and inner join the same?
What is sql and its types?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
Why do we need pl sql?
How many joins in sql?
Differentiate between syntax and runtime errors.
what is primary key? : Sql dba
What is column?
what is query cache in mysql? : Sql dba
What do you understand by pl/sql records?
Why do you partition data?
