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
26536 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 is the difference between request group and request security in oracle apps?

5050

In oracle application how do you debug or trace errors?

639

In sequence i want to 11 and 15th values how we will write?

1573

Explain what are the tables of auto invoice?

648

List the various types of value set.

623

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

1953

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

681

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

1689

What do you understand by soa?

694

What are the Standard Reports and Forms in HRMS?

1773

how do you describe O2C along with tables

2310

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

630

What do you understand by concurrent programs?

619

How can a process be deployed in soa?

700

How do you register report in oracle apps?

633