Find out the 3rd highest salary?
Answers were Sorted based on User's Feedback
Answer / xxx
select ename, salary from
(Select ename, salary, rownum
FROM emp where rownum<=3
Order by salary )
where rownum = 1
;
| Is This Answer Correct ? | 7 Yes | 20 No |
How to call a javascript function from pl sql?
What is sql and how does it work?
In testing where do we use sql language and how it helps in testing?
What is a memo field?
what is a composite key ? : Sql dba
What is the difference between a subquery and a join?
How toimport .dmp file in lower version of oracle from higher version ?
How to find the count of letter "L" in HELLO
What is sql partition?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
What is user defined functions?
what is the Default Libraries for Oracle Report 6i
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)