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!
-
Selecting multiple maximum values??
Thanks, no its not a school project (Yes I did read the Posting Policies!) Im just creating a database for a friend who tends to misplace some of his DVDs cuz he cant keep track of them. In regards to the MAX, I just used the Age because I couldnt be botheredn writing the other table which has... -
Selecting multiple maximum values??
wait... sorry, limit is supposed to go in the DVDloan table -
Selecting multiple maximum values??
Ok, sorry, different timezones means a delayed response. I have 3 tables, well 4 but ones not needed: borrower(id, first_name, surname, age) DVD(id, title, rating, limit) DVDloan(first_name, surname, rating) (by the way its my own little DVD library system) What I need to list is: id... -
Selecting multiple maximum values??
Yep that worked! However when I wanted to add fields from another table, I get "You tried to execute a query that does not include the specified expression.. as part of an aggregate function" Ive made heaps of large databases and the SQL works fine with aggregates and multiple tables, but never... -
Selecting multiple maximum values??
Is it possible to get the maximim value (for example an age) for every different value (eg surname) in another field of the record?? For example the oldest person for every surname present in a surname column? I've tried subqueries, distinct, etc and I cant get it.
