Oracle

subquery help

Please support our Oracle advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Dec 2008

Posts: 297

Reputation: firoz.raj is an unknown quantity at this point

Solved Threads: 1

firoz.raj

Offline

Posting Whiz in Training

subquery help

Jun 30th, 2009

Can anyone tell me .what will return this subquery.any help would
be Greatly appreciated.kindly help me.it will return single row or
multiple row if single then how.kindly let me know some idea.

 Help with Code Tags 
 oracle Syntax (Toggle Plain Text) 
SELECT * FROM sub WHERE job=(SELECT job FROM job)
select * from sub where job=(select job from job)

Last edited by firoz.raj; Jun 30th, 2009 at 5:58 am.

•

Join Date: Sep 2008

Posts: 123

Reputation: cgyrob is on a distinguished road

Solved Threads: 18

cgyrob

Offline

Junior Poster

Re: subquery help

Jun 30th, 2009

Not sure what you are asking. This statement will most likely return an error. (Multiple values returned when expecting single value)

To make it work you will either have to use an "in" instead of "=" for your sub query or use a where clause within your sub to limit the return values to one value.

 Help with Code Tags 
 SQL Syntax (Toggle Plain Text) 
SELECT * FROM sub WHERE job IN (SELECT job FROM job)
Select * from sub where job in (select job from job)

 Help with Code Tags 
 SQL Syntax (Toggle Plain Text) 
SELECT * FROM sub WHERE job = (SELECT job FROM job WHERE value = something )
Select * from sub where job = (select job from job where value = something )