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

Categories >> Software >> ERP CRM >> Oracle Apps >> Oracle Apps Technical
Suggest New Category

What is the result of this query ?

SELECT * FROM EMP WHERE ROWNUM = 1

Question Posted / nakul28

25 Answers
28140 Views
IBM, Satyam, I also Faced
E-Mail Answers

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