Home » Other » Training & Certification » plz help me out with this query
plz help me out with this query [message #254674] Fri, 27 July 2007 08:03 Go to next message
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.
Re: plz help me out with this query [message #254677 is a reply to message #254674] Fri, 27 July 2007 08:11 Go to previous messageGo to next message
iamdurai
Messages: 96
Registered: April 2007
Location: Chennai
Member

Hi,

What you have to tried ?

Reds
Thangam.
Re: plz help me out with this query [message #254685 is a reply to message #254674] Fri, 27 July 2007 08:49 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: wants address of oracle application training centers in delhi/NCR
Next Topic: Snapshots with referential Integrity
Goto Forum:
  


Current Time: Thu Mar 28 05:35:20 CDT 2024