What is the result of this query ?

SELECT * FROM EMP WHERE ROWNUM = 1

Answers were Sorted based on User's Feedback



What is the result of this query ? SELECT * FROM EMP WHERE ROWNUM = 1..

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

What is the result of this query ? SELECT * FROM EMP WHERE ROWNUM = 1..

Answer / l.l.n.reddy

it will dispaly the first record only.

Is This Answer Correct ?    36 Yes 5 No

What is the result of this query ? SELECT * FROM EMP WHERE ROWNUM = 1..

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

What is the result of this query ? SELECT * FROM EMP WHERE ROWNUM = 1..

Answer / prakash

it will display first row in a table

Is This Answer Correct ?    25 Yes 6 No

What is the result of this query ? SELECT * FROM EMP WHERE ROWNUM = 1..

Answer / honey nasies

It will display only the first record in the table

Is This Answer Correct ?    20 Yes 4 No

What is the result of this query ? SELECT * FROM EMP WHERE ROWNUM = 1..

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

What is the result of this query ? SELECT * FROM EMP WHERE ROWNUM = 1..

Answer / farhad alam

it will display fst one record.

Is This Answer Correct ?    16 Yes 4 No

What is the result of this query ? SELECT * FROM EMP WHERE ROWNUM = 1..

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

What is the result of this query ? SELECT * FROM EMP WHERE ROWNUM = 1..

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

What is the result of this query ? SELECT * FROM EMP WHERE ROWNUM = 1..

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

Post New Answer

More Oracle Apps Technical Interview Questions

Can we create tables in apps schema?

0 Answers  


we are inserting,update and delete the data we can do simultaniously, but it will show error in updation? what to do?

4 Answers  


What is count(*) from po_vendors(any table)?

0 Answers  


how to find the custom directory in front end.

1 Answers   IBM, Sierra Atlantica,


what are the error tables in OM

2 Answers   Fujitsu,






what is difference between po_headers_all and po_headers

2 Answers   NTT Data,


What does appl_top directory contain?

0 Answers  


After completing Report customization process.suppose we have 10 report parameter in report so, that we re-register that parameter in concurrent program?

3 Answers   IBM,


In what situation u create the BPA.

2 Answers   Accenture,


What are basic steps for AIM?

2 Answers  


Do you know what are user profiles in apps. Any examples you can give?

0 Answers  


what u did after ur btech(2009) till now? why did u prefer oracle apps technical?

1 Answers   Intelligroup,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)