shakthi

 Profile Answers by shakthi 

• Jan 24th, 2007

 

2. select * from tabname where comm=NULL;

Shri

• Jan 30th, 2007

 

select rownum , ename ,empidfrom emp group by rownum,ename,empid having(mod(rownum,2) = 1);

srihari

• Jan 30th, 2007

 

Display all records those commission is NULL
SELECT * FROM EMP WHERE comm IS NULL;

Guest

• Jan 31st, 2007

 

select * from emp where (rowid,1) in (select rowid, mod(rownum,2) from emp)

ajitmelepat

• Feb 10th, 2007

 

i think, the answer that has given by shakthi, won't work .try it : Select * from < table > where Comm is null .:)

csr

• Feb 28th, 2007

 

HI

I am getting the correct result by using this query
select * from emp where (rowid,1) in (select rowid, mod(rownum,2) from emp)

Can u differentiate rowid and rownum?

Kiran_kiran

 Profile Answers by Kiran_kiran 

• Mar 8th, 2007

 

hey i think this will help u

for odd rows

select *from (select rownum r,e.* from emp e) where mod(r,2)=1

vishnu vardhan reddy

 Profile Answers by vishnu vardhan reddy 

• Sep 16th, 2008

 

select  e.* from( select rownum rn ,ename,sal from emp) e
  where  mod(rn,2)=0

jayshree13

 Profile Answers by jayshree13 Questions by jayshree13

• May 13th, 2011

 

Ans:1. select * from emp where (rowid,1) in (select rowid,mod(rownum,2) from emp);

Ans:2: select * from emp where comm is null;