Answer / ajit nayak

select *from emp
minus
select *
from emp
where rownum <= (select count(*)-3 from
emp);

Answer / swastik

SELECT * FROM
(
SELECT * FROM Emp
ORDER BY ROWNUM DESC
)
WHERE ROWNUM <= 3;

Answer / ashwin

if emp table is having 10 records then
1)for first 6 write

select ename,sal from(select ename,sal from emp order by sal
desc) where rownum <7;

2)for last 3 write

select ename,sal from(select ename,sal from emp order by sal
desc) where rownum >7;

Answer / sanjay

SELECT ROWNUM AS rank, employee_id
FROM (SELECT employee_id
FROM employees
ORDER BY employee_id DESC)
WHERE ROWNUM<=3

Answer / shekaran04

Hi,
First thing you cannot use " ROWNUM > (somthing) "
And to get last three records...

Select *from emp
minus
Select *from emp where rownum <(select Count(*) from emp)-
3;

Good Luck...

Answer / mohammed shahid

select distinct TOP3 from emp order by rownum desc;

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

0 Answers  

What is linq to sql?

0 Answers  

How to assign sql query results to pl sql variables?

0 Answers  

Can we insert data in view?

0 Answers  

What is the difference between truncate and drop statements?

0 Answers  

what is rdbms? : Sql dba

0 Answers  

What is sql prepared statement?

0 Answers  

what is text? : Sql dba

0 Answers  

Describe the Index, Types of index, At what situation we have used? Which one s better than others?

1 Answers   IBM, TCS,

Does sap use sql?

0 Answers  

explain the options of myisamchk to improve the performance of a table. : Sql dba

0 Answers  

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

0 Answers