Home » SQL & PL/SQL » SQL & PL/SQL » Oracle 9i Help!
Oracle 9i Help! [message #6728] Fri, 02 May 2003 14:38 Go to next message
Nazma Bepat
Messages: 34
Registered: May 2003
Member
Can someone please help me out in the following:

A. Write a query to display the PRODID, DESCRIP from the product table and also display the ORDID, ITEMID, ACTUALPRICE from the item table. Use table alias’s in your answer.

B. Modify question A so that it displays the information only when the qty in the item table is greater than 3000.

C. Modify question B so that it displays the information only when the qty is less than 1000 and the actualprice is greater than 50.

Thanks for your help!

Nazma

Report message to a moderator

Re: Oracle 9i Help! [message #6729 is a reply to message #6728] Fri, 02 May 2003 14:41 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Nazma, this is not the appropriate place to post homework questions.

Report message to a moderator

Previous Topic: query to return two max columns
Next Topic: HELP! SQL*PLUS hangs for no apparent reason
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 04:09:47 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.