Interested to Buy Any Domain ? << Click Here >> for more details...
What is the result of this query ?
SELECT * FROM EMP WHERE ROWNUM = 1
- 25 Answers
- 32740 Views
- IBM, Satyam, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rajesh
It gives all the details of the Employee who is in the first
row of the table .
Regards
Rajesh
baburajeshd@gmail.com
| Is This Answer Correct ? | 58 Yes | 8 No |
Answer / kumar
THE CONDITION ROWNUM = 1 EVALUATE TRUE(i.e 1=1) HENCE
IT DISPLAY THE FIRST RECORD FROM THE EMP TABLE.
| Is This Answer Correct ? | 28 Yes | 3 No |
It will display only the first record in the table
| Is This Answer Correct ? | 20 Yes | 4 No |
Answer / apps
ROWNUM is generally used in >=, <=, <, >. But there is
exception, you can use it = also but only with 1 as
ROWNUM=1, it will display first record in table. If you use
ROWNUM=10…. Or any number other than 1 then it will not
display any records.
| Is This Answer Correct ? | 15 Yes | 0 No |
Answer / ravi
Puople who don't have knowledge or don't know concept,
don't post the answers blintly. please...
I don't know why some stupid guys/girls are giving wrong
answers?
| Is This Answer Correct ? | 12 Yes | 5 No |
Answer / vidyasagar
This is the actual answer
SQL> select * from emp where rownum=1;
EMPNO ENAME JOB MGR HIREDATE
SAL COMM DEPTNO
--------- ---------- --------- --------- --------- ---------
--------- ---------
123 SATYA 234
2000 40
got it
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / smruti
Guys,
Posting an answer is a nice effort, that means you are
trying to help other people overcome the trouble ahead.
But be cautious when posting an answer in public. Posting
wrong answers can be a sin.
Please be silent if you dont know atleast. After a damn
strong and correct answer from someone called Apps why u
people don't verify with urself. Archana don't show off
please.
SQL> SELECT * FROM EMP WHERE ROWNUM = 1;
EMPNO ENAME
---------- ----------------------------------------
1 SMRUTI
SQL> SELECT * FROM EMP WHERE ROWNUM = 22;
no rows selected
| Is This Answer Correct ? | 5 Yes | 1 No |
what is user exit and wat program do we write in user exit?
what is inbound and outbound interface?
what is tuning in oracle apps technical
What is multoorg and what is it's level or structure
can we write multiple procedures in package with same name like A p1,p2(parameters) B p1,p2(same parameters)
in ap_terms table what data will be stored
In one flat file i got headers and lines data how you can write control file now ?
Hi, can anybody tell me where is the requirement of Oracle Apps (functional+technical) in industry,Iwant to join there,If possible than call me---9313174232
Are you familiar with internet architecture of oracle apps 11i?
How to compile the Forms & Reports in Linux Apps Server which are created in WindowsXP client?
what is meant by boilerplates?
What are the tables in GL?
Oracle Apps Technical 
