This is the actual answer SQL> select * from emp where rownum=1;

What is the result of this query ?

SELECT * FROM EMP WHERE ROWNUM = 1

Question Posted / vidyasagar

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

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what are the balancing segments in AR?

2040

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

3566

WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

3004

What is sca and how is it useful?

1048

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2573

Which oracle apps version you are very confident in?

1174

Explain what are the tables of auto invoice?

1094

what is pay run id ?

2127

What are the benefits of using soa architecture?

1178

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

1188

Tell me how to debug the report?

1063

what is global tempory table?

7123

List the types of flexfield?

989

In hierarchical structure of a database? we have write query from where we should start?

2171

where to define interorganization transaction charges and what are the different options?

2369