Advertisement
Guest User

Untitled

a guest
Apr 19th, 2014
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.27 KB | None | 0 0
  1. SELECT DISTINCT artistName, trackName, trackPath, imagePath, year, albumName, bpm, genre1, genre2, genre3
  2. FROM Tracks WHERE genre1='Pop' or genre2='Pop' or genre3='Pop'
  3. GROUP BY albumName
  4. ORDER BY artistName
  5.  
  6. GROUP BY albumName
  7.  
  8. GROUP BY artistName, albumName
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement