How to find 8th person record in a table?
Plz mail ur answers to
mak2786@gmail.com
Regards
Arun
Answer Posted / fahad
select * from emp where rownum<=8
minus
select * from emp where rownum<=7
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What do you mean by Oracle MEDIA RECOVERY?
QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS
How many segment are present in Oracle Manufacturing
1. What is PO rate variance gain and loss?
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
what are the API of GL,PO,AP
Explain how to close periods in ar. : oracle accounts receivable
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
Explain prerequisites and post activities of oracle database installation
key flexfield structure
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable