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;

How many types of relationship are there?

0 Answers  

How can you create an empty table from an existing table?

0 Answers  

how view used for security purposes?

3 Answers   Glam India,

What is cost in sql execution plan?

0 Answers  

What is cursor explain with example?

0 Answers  

How do I remove sql developer from windows 10?

0 Answers  

Whate is use of MOD function in pl/sql.

3 Answers   Oracle,

How do you select unique values in sql?

0 Answers  

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance

5 Answers   Target,

Can we use more than one null value for unique key?

31 Answers   A1 Technology, Wipro,

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

0 Answers  

how can we destroy the session, how can we unset the variable of a session? : Sql dba

0 Answers