OraFAQ Forum: Training & Certification » plz help me out with this query

Home » Other » Training & Certification » plz help me out with this query

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

plz help me out with this query [message #254674]

Fri, 27 July 2007 08:03

madhavi122006
Messages: 3
Registered: July 2007

Junior Member

hello guys plz help me out with this query

table:
Product(maker, model, type)

sample data:
maker model type
A 1232 PC
A 1233 PC
A 1276 Printer
A 1298 Laptop
A 1401 Printer
A 1408 Printer
A 1752 Laptop
B 1121 PC
B 1750 Laptop
C 1321 Laptop
D 1288 Printer
D 1433 Printer
E 1260 PC
E 1434 Printer
E 2111 PC
E 2112 PC

query:
Find out the makers that sale PCs but not laptops.

Report message to a moderator

Re: plz help me out with this query [message #254677 is a reply to message #254674]

Fri, 27 July 2007 08:11

iamdurai
Messages: 96
Registered: April 2007
Location: Chennai

Member

Hi,

What you have to tried ?

Reds
Thangam.

Report message to a moderator

Re: plz help me out with this query [message #254685 is a reply to message #254674]

Fri, 27 July 2007 08:49

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Please read and follow How to format your posts and How to get a quick answer to your question: TIPS AND TRICKS
Make sure that lines of code do not exceed 80 or 100 characters when you format.
Please always post your Oracle version (4 decimals).

We don't make your homework but we help you to make them.
First let you know what you already tried and why it is wrong.

Regards
Michel

Report message to a moderator

Previous Topic:	wants address of oracle application training centers in delhi/NCR
Next Topic:	Snapshots with referential Integrity

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 07:00:38 CST 2024