Answer Posted / brajesh kumar
SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT
(DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal);
Is This Answer Correct ? | 15 Yes | 8 No |
Post New Answer View All Answers
Give syntax for SQL and ORACLE joins.
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
What are the attributes of cursor?
What are the different types of record groups in oracle? Explain each of them
What is the max number of columns in an oracle table?
What is merge in oracle?
Name the three major set of files on disk that compose a database in Oracle?
How do you find current date and time in oracle?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
What is recovery manager in Oracle?
What are the most common interview questions on ETL Testing for experience?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
Explain mutating triggers.
What is the difference between view and materialized view in Oracle?
How to convert numbers to characters in oracle?