Fazlur Rahiman

• Jul 25th, 2006

 

What is the meaning of 3,4,5,6? Is Record no or Employee No?

What is the Sum of field name?

sivareddy

• Aug 5th, 2006

 

select * from emp  where rowid in(

             select* from emp where rowid <=6

minus

select * from emp where rowid=3);

madhavi.p

• Sep 1st, 2006

 

The previous person mentioned that one it won't work,try with this it will give the correct result,why means that rowid is returning so many values

select sum(sal) from emp  where  rowid in
 ( select rowid from emp where rownum <= 6 minus select rowid from emp where rownum <=3 );

Suneel

• Sep 9th, 2006

 

This should also work

select sum(sal) from emp  where  rowid between 3 and 6;

Sachin

• Sep 27th, 2006

 

Hi,

Madhavi is absolutely right..

select sum(sal) from emp  where  rowid in
 ( select rowid from emp where rownum <= 6 minus select rowid from emp where rownum <=3 );

It will work fine..

-regards

Sachin

• Sep 27th, 2006

 

Madhavi,

It seems that the query you are firing is taking 3,4,5,6 as rownum,then why can't we go straight as below..

select sum(sal) from emp where rownum in ('3','4','5','6');

You are fetching the rowid first with the help of rownum as 3,4,5,6.

Please correct me if I am wrong!!

-Regards

Athar

 Profile 

• Oct 14th, 2006

 

The query need to be modified as below

1. select sum(sal) from emp  where  rowid in
  ( select rowid from emp where rownum <= 6 minus select rowid from emp where rownum <=2 );

2. rownum cannot be used for evaluating group functions. Oralce returns NULL value for the below query

select sum(sal) from emp where rownum in (3,4,5,6);

or

select sum(sal) from emp where rownum in ('3','4','5','6');

In fact, rownum is numeric value. So, it must not be enclosed in quotes.

ajitmelepat

• Feb 10th, 2007

 

hello, try this one it'll also workselect sum(sal) from (select a,rownum rw from emp)where rw between 3 and 6 ;

maddy

• Jul 31st, 2007

 

SELECT sum(esal) FROM ( SELECT a.*, ROWNUM r FROM EMPmanoj a) WHERE r BETWEEN 2 AND 3

Imran_Javed

 Profile Answers by Imran_Javed 

• May 8th, 2008

 

SELECT SUM(sal)
FROM (SELECT ROWNUM rn ,  sal FROM (SELECT sal FROM emp))
WHERE  RN BETWEEN 3 AND  6;

Praveen2384

 Profile Answers by Praveen2384 

• Sep 9th, 2008

 

If it is employee no and employee no is unique the SQL is below

Select sum(column_name) from Table_name where rownum=>3 and rownum<=6 and Order by employee_number.

jayshree13

 Profile Answers by jayshree13 Questions by jayshree13

• May 13th, 2011

 

select sum(sal) from emp where rowid in(select rowid from emp where rownum<=6 minus 

select rowid from emp where rownum<=2);

alekhya

• Aug 6th, 2012

 

rownum always starts with 1

alekhya

• Aug 6th, 2012

 

SELECT SUM(SAL) FROM (SELECT ROWNUM R,EMPNO,ENAME,sal FROM EMP)
where r in (3,4,5,6)

Waseem Mehmood

 Profile Answers by Waseem Mehmood 

• Aug 23rd, 2012

 

SELECT sum(sal)
FROM (SELECT Sal, Empid,
RANK () OVER (ORDER BY empid DESC) EmpRank
FROM player)
WHERE EmpRank IN (3, 4, 5, 6);

smily08

 Profile Answers by smily08 

• Aug 29th, 2012

 

Code
 

smily08

 Profile Answers by smily08 

• Aug 30th, 2012

 

Code