|
||||||
| 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). |
 |
|
|
LinkBack | Thread Tools | Search this Thread | Display Modes |
03-03-2008, 11:28 PM
|
|||
|
|||
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.     
|
| Sponsored Links |
|
|
|
03-04-2008, 07:58 AM
|
|||||
|
|||||
|
And what do you have so far - where are you stuck?
__________________
CodeCall Blog | CodeCall Wiki | Shareware Site | Linux Forum | Write a Blog Don't hesitate to ask any questions that you have! Check out our ASCII Calculator!
|
|
03-04-2008, 08:01 AM
|
|||
|
|||
|
i got it ...was hoping i could get the relational algebra
|
|
«
Previous Thread
|
Next Thread
»
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
Linear Mode
|
|
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 10:35 AM.
