Answer / prabhudatta

SELECT * FROM (SELECT * FROM EMP ORDER BY EMP_NO) WHERE
ROWNUM=1

UNION

SELECT * FROM (SELECT * FROM EMP ORDER BY EMP_NO DESC)
WHERE ROWNUM=1;

Answer / sudipta santra

For the 1st row:

select * from emp where rownum<2 order by empno;

For the last row:

select * from emp where rownum<2 order by empno desc;

Answer / nathan

SELECT *
FROM (SELECT emp.*, ROWNUM rn
FROM emp)
WHERE rn = 1 OR rn = (SELECT COUNT (*)
FROM emp);

Answer / rajesh

SELECT * FROM (SELECT * FROM EMP ORDER BY EMP_NO) WHERE
ROWNUM < 2

UNION

SELECT * FROM (SELECT * FROM EMP ORDER BY EMP_NO DESC)
WHERE ROWNUM < 2;

Answer / ajay reddy

Select * from (select e.*,rownum r from emp e) where r in(1,(select count(*) from emp));

Answer / ajitnayak

SELECT *
FROM EMP
WHERE ROWID = (SELECT MIN(ROWID) FROM EMP)
UNION
SELECT *
FROM EMP
WHERE ROWID = (SELECT MAX(ROWID) FROM EMP)

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1 Answers  

How to rebuild an index in oracle?

1 Answers  

Explain the truncate in oracle?

1 Answers  

What operating systems are supported by oracle database 10g xe?

1 Answers  

How can we find the size of a database?

2 Answers  

9. Display the client name and order date for all orders using the JOIN . . . USING method.

2 Answers   Wipro,

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1 Answers  

How to use windows user to connect to the server?

1 Answers  

What are the various oracle database objects?

1 Answers  

How do I uninstall oracle client from windows?

1 Answers  

1.display list of all users from ur data base.what is the query?

3 Answers   CGI, IBM,

How to store pictures on to the database?

1 Answers