Interested to Buy Any Domain ? << Click Here >> for more details...
Given an employee table, how would you find out the second
highest salary?
- 9 Answers
- 14585 Views
- I also Faced
- E-Mail Answers
Answer Posted / vivek mohan singh
select salary from tablename order by salary desc limit 1,1;
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
Explain about a primary key?
Explain about xml databases?
What is DB Development software?
Explain the cube operator?
State the acid rules?
How to use timestamp datatypes
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
How to replace not in with not exist?
What is the physical representation for a many-to-many relationship?
What is dbms explain in brief?
How to use online Backups?
How is data stored in dbms?
