SELECT * FROM EMP WHERE ROWNUM = 1 it will be returned only one record. we

What is the result of this query ?

SELECT * FROM EMP WHERE ROWNUM = 1

Question Posted / rao

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

Answer Posted / rao

SELECT * FROM EMP WHERE ROWNUM = 1
it will be returned only one record. we have to display the
more than records using below mentioned statement....

SELECT * FROM EMP WHERE ROWNUM < 4...

Answer is correct ... checked also

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what are the balancing segments in AR?

2107

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

2669

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2637

What is oracle soa suite?

1252

Explain oracle apps architecture.

1262

How can a process be deployed in soa?

1280

What do you understand by a set of books?

1121

what is the difference between request group and request security in oracle apps?

5911

Explain what are the tables of auto invoice?

1143

please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

3672

Can you differentiate between mediator and osb?

1156

What are file in oracle.

2245

What are the benefits of using soa architecture?

1255

how can develope the po variance and po summary report? with tables mandatory columns and query please?

2396

List the various types of value set.

1088