Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
What would be the syntax for this?
Hi:
I have a table:
ROOM_NO (int) ... SINGER_NO (int) ... SONG_NO (char)
The entire table usually looks like this:
ROOM_NO ... SINGER_NO ... SONG_NO
3 ...................... 1 ........................ 24
1 ...................... 2 ........................ 25
1 ...................... 3 ........................ 30
2 ...................... 3 ........................ 41
1 ...................... 3 ........................ 23
2 ...................... 2 ........................ 20
2 ...................... 3 ........................ 99
2 ...................... 3 ........................ 42
1 ...................... 1 ........................ 36
1 ...................... 5 ........................ 23
3 ...................... 4 ........................ 20
2 ...................... 6 ........................ 1
Using a WHERE on the Room_No and getting ONE unique set of consecutive Singer_No in Singer_No ORDER. The following is the result I'm looking for.
ROOM_NO ... SINGER_NO ... SONG_NO
1 ...................... 1 ........................ 36
1 ...................... 2 ........................ 25
1 ...................... 3 ........................ 30
1 ...................... 5 ........................ 30
Although Singer_No 1 and 3 are in the table more than once for Room_No 1, I need the first occurance of the singer number only.
At first it seemed simple, but I got nowhere :o(
Thanks for your help.
Mal
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement