THE CONDITION ROWNUM = 1 EVALUATE TRUE(i.e 1=1) HENCE IT DISPLAY THE FIRST

What is the result of this query ?

SELECT * FROM EMP WHERE ROWNUM = 1

Question Posted / kumar

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

what is the differences between internal requisition and internal sales order?

2643

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

1074

Do you know where we can check the status of po?

1256

Explain what are the tables of auto invoice?

1132

In oracle application how do you debug or trace errors?

1091

Can you explain the difference between architecture followed in 10g & 11g?

1052

Explain oracle apps architecture.

1222

Tell me how to find the custom directory in front end?

1095

What do you understand by concurrent programs?

1074

what are the prerequisites for costing transactions?

3126

How to move the one file from one instance to another instance? And your scripts also?

1097

What do you understand by a set of books?

1099

please send me forms, xml pulisher questions,answers

2101

Do you know what is applysys in oracle application database schema, what is apps?

1167

How can we import the data into a database using sql * loader?

1173