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

how can i print random rows in plsql table

2577

What do you understand by soa and what are the benefits of using this architecture?

1148

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

1169

Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

2178

How can a process be deployed in soa?

1338

q)what are the validations in sql*loader

2461

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

1227

what are the balancing segments in AR?

2154

What do you understand by a set of books?

1155

how to print multi lay outs,muti currency,muti language in xml publisher

12400

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

2711

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

1144

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

1156

What are the Standard Reports and Forms in HRMS?

2383

Are you familiar with internet architecture of oracle apps 11i?

1128