Lost Password?

Go Back   CodeCall Programming Forum > Web Development Forum > Database & Database Programming
Reload this Page SQL query
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Database & Database Programming MySQL, Oracle, SQL, PL/SQL, ABAP, Smart Forms, and other databases and languages. A database is an organized body of related information used in many websites (including CC).

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-03-2008, 11:28 PM
sayhello2ay sayhello2ay is offline
Newbie
  
Join Date: Mar 2008
Posts: 2
Rep Power: 0
sayhello2ay is on a distinguished road
Default SQL query
Actor (Aname: varchar(40), Ano: varchar(6)) Ano is pk
Movie (Mname: varchar(40),mno: varchar(8)) Mno is pk
PlayIn (Ano, Mno, Pay: Integer) Ano and Mno are fk referencing Acotr and Movie respectively.

Actor(Aname, Ano)
A Bingo, A1
B Castro, A2
C Katie, A3
S Hommy, A4
J Tammy, A5
K loren, A6

Movie(Mname, Mno)
Gladiator, M1
Cast, M2
Dog, M3
Jilters, M4

PlayIn(Ano,Mno,Pay)
A1 M1 800
A1 M2 1500
A2 M2 78
A2 M3 1750
A2 M4 2301
A3 M2 904
A3 M3 629
A4 M2 565
A4 M3 5695
A4 M4 1255
A5 M1 989
A5 M4 238
A6 M2 137
A6 M3 236
A6 M4 545

QUESTION: write SQL query to find the names of actors who earned less than 'B Castro' in each movie that 'B Castro' played in.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

Sponsored Links
  #2 (permalink)  
Old 03-04-2008, 07:58 AM
Jordan's Avatar   
Jordan Jordan is online now
Administrator
  
Join Date: Nov 2005
Location: Hendersonville, NC
Age: 25
Posts: 4,512
Last Blog:
Zend: PHP Security Web...
Rep Power: 50
Jordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud of
Send a message via ICQ to Jordan Send a message via AIM to Jordan Send a message via MSN to Jordan
Default
And what do you have so far - where are you stuck?
__________________
CodeCall Blog | CodeCall Wiki | Shareware Site | Linux Forum | Write a Blog
Chat with other CodeCall members on IRC; connect to irc.codecall.net and join #codecall
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 03-04-2008, 08:01 AM
sayhello2ay sayhello2ay is offline
Newbie
  
Join Date: Mar 2008
Posts: 2
Rep Power: 0
sayhello2ay is on a distinguished road
Default
i got it ...was hoping i could get the relational algebra
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

« Previous Thread | Next Thread »


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL commands in Windows Forms karateboy02 Managed C++ 4 08-11-2007 08:08 AM
Best program for SQL database manipulation Rhadamanthys Database & Database Programming 3 07-02-2007 02:32 PM
Access database query using sql help !!! ORACLE Visual Basic Programming 4 04-16-2007 01:12 PM
Clear my sql query? reachpradeep Database & Database Programming 0 03-04-2007 12:25 AM
Oracle has more Flaws than MS SQL? Jordan Database & Database Programming 9 12-05-2006 09:39 AM


All times are GMT -5. The time now is 03:01 PM.

Contact Us - Programming Forum - Archive - Top

CodeCall

Contest Stats

John ........ 87.50000
dargueta ........ 75.00000
Xav ........ 50.00000
MeTh0Dz ........ 20.00000
gaylo565 ........ 18.00000
Johnnyboy ........ 3.00000

Contest Rules

Sponsors

Linux Forums
Electronic Music

Ads