Answer Posted / venkat
select * from emp minus select * from emp where rownum <= (select count(*) - &n from emp);
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
what is the use of system.effective.date variable in oracle?
How to use values from other tables in update statements using oracle?
How many file formats are supported to export data?
How to do a full database export?
How to use fetch statement in a loop?
How to drop a stored function?
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.
How to connect to oracle using service name instead of sid?
What is merge in oracle?
What is the relation of a user account and a schema?
what are steps for interface? where is exchange rate defined in which table?
How many types of segments in Oracle?
Explain what are the uses of rollback segment?
How to create a new table in your schema?