Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: stuart1980
- Order by date
-
Complex query: limit occurences of certain value
Lets say we have a 'person' table and a 'car' table. And the primary key for these tables are person_id and car_id respectively. A person can have many cars. How could you select the first 3 cars for each person in ONE query? I don't want to requery for each person, nor do I want to filter...- stuart1980
- Thread
- Replies: 2
- Forum: ANSI_SQL
