Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373315 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 / tarun
SELECT salary FROM tb_salary ORDER BY salary DESC LIMIT 2,1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is an implicit commit?
When is the explicit cursor used ?
The in operator may be used if you know the exact value you want to return for at least one of the columns.
Can %notfound return null after a fetch?
What do you mean by query optimization?
What is sql trigger example?
how are mysql timestamps seen to a user? : Sql dba
Does access use sql?
What is left join in postgresql?
Is sqlite good enough for production?
What is trigger and how to use it in sql?
What are joins in sql?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
When sql appeared?
Can we insert data in view?
