SQL - consider that we r having table name emp....now the question is 1.how should we print the odd rows f

GeekInterview.com

I am new, Sign me up!

GeekInterview.com > Tech FAQs > SQL

Go To First | Previous Question | Next Question

SQL | Question 102 of 215

Print

consider that we r having table name emp....
now the question is
1.how should we print the odd rows from that table?
2.how should we print the rows where comm=NULL.

Reply ASAP

Total Answers and Comments: 8

Last Update: September 16, 2008 Asked by:

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

January 24, 2007 23:44:39

Member Since: January 2007 Contribution: 3

RE: consider that we r having table name emp.......

2. select * from tabname where comm NULL;

Is this answer useful? Yes | No

January 30, 2007 05:21:31

Shri

RE: consider that we r having table name emp.......

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

Is this answer useful? Yes | No

January 30, 2007 17:41:17

srihari

RE: consider that we r having table name emp.......

Display all records those commission is NULL

SELECT * FROM EMP WHERE comm IS NULL;

Is this answer useful? Yes | No

January 31, 2007 04:40:28

RE: consider that we r having table name emp.......

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

Is this answer useful? Yes | No

February 10, 2007 02:11:59

ajitmelepat

RE: consider that we r having table name emp.......

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

Is this answer useful? Yes | No

February 28, 2007 13:13:46

csr

RE: consider that we r having table name emp.......

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?

Is this answer useful? Yes | No

March 08, 2007 11:40:27

Member Since: March 2007 Contribution: 2

RE: consider that we r having table name emp.......

hey i think this will help u

for odd rows

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

Is this answer useful? Yes | No

September 16, 2008 09:34:48

vishnu vardhan reddy

Member Since: September 2008 Contribution: 6

RE: consider that we r having table name emp....now the question is 1.how should we print the odd rows from that table?2.how should we print the rows where comm=NULL.Reply ASAP

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

Is this answer useful? Yes | No

Sponsored Links

About Us - Privacy Policy - Terms and Conditions - Contact - Ask Question - Propose Category - Site Updates

Copyright © 2005 - 2010 GeekInterview.com. All Rights Reserved