Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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..

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..

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..

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..

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..

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..

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..

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..

Puople who don't have knowledge or don't know concept,

I don't know why some stupid guys/girls are giving wrong

 Is This Answer Correct ? 12 Yes 5 No

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

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..

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

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

More Oracle Apps Technical Interview Questions

What is the use of format trigger?

How to create user and how u attach with responsibility.

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

What are the requests groups?

what is multi org structure?

What are different execution methods of executabls?

in procedure how to return a value

What will happen If I am not giveing the Suspense accout while defineing the Set of Books in GL?

is it possible to run the interface without using oracle apps?

diff between key and descriptive flexfield.

what is fiscalcalendar?

what is global tempory table?

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