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

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

What is the use of format trigger?

4 Answers   Cap Gemini, IBM,


How to create user and how u attach with responsibility.

2 Answers   Accenture,


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 are the requests groups?

3 Answers  


what is multi org structure?

3 Answers   Covansys, TCS,






What are different execution methods of executabls?

1 Answers   Genpact, TCS,


in procedure how to return a value

3 Answers  


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

2 Answers   TCS,


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

2 Answers   Accenture,


diff between key and descriptive flexfield.

4 Answers   Convergys,


what is fiscalcalendar?

3 Answers   CTS,


what is global tempory table?

1 Answers   BirlaSoft,






Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (791)
  • 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)