Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361240 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 / subahar
SELECT MAX(average) AS Expr1
FROM sp
WHERE (average NOT IN
(SELECT MAX(average) AS Expr1
FROM sp AS sp_1))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the different types of a subquery?
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
What is forward declaration in pl sql?
Can we call procedure in select statement?
What is a crud api?
The in operator may be used if you know the exact value you want to return for at least one of the columns.
Is oracel sql developer written in java?
Show the two pl/sql cursor exceptions.
How does pl sql work?
What is the sql query to display the current date?
What is faster join or subquery?
how would concatenate strings in mysql? : Sql dba
Is it possible to read/write files to-and-from PL/SQL?
What is error ora-01000: maximum open cursors exceeded
What is trigger in pl sql with examples?
