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!

Register Log in
  • Congratulations Chriss Miller 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: *

  1. colouredFunk

    SQL statement - Distinct and groupinf problem

    Hey thanks PHV that's almost perfect!!! Is it possible to make a slight change to it - It still shows the duplicate records - but only when all the information is the same. I really really appreciate your help :D :D
  2. colouredFunk

    SQL statement - Distinct and groupinf problem

    I'm having real trouble with this query, can't seem to get it right. These are the rules 1. If somebody has played more than once, only the highest score as calculated in one above should be displayed 2. the results should display correct details by total score in descending order 3. In the...
  3. colouredFunk

    SQL statement - Distinct and groupinf problem

    hey thanks for your reply :D I've taken off DISTINCT (thanks for that, it doesn't effect the results taking it off at all) and removed leaderboard.total from the GROUP BY - but now the information doesn't display correct. i.e. the date, handicap, score, is from different record than the total...
  4. colouredFunk

    SQL statement - Distinct and groupinf problem

    can someone look at the statement for me, it's not giving me distinct names, SELECT DISTINCT TOP 10 leaderboard.name, Last(leaderboard.date_cr) AS date_cr, Last(leaderboard.handicap) AS handicap, Max(leaderboard.total) AS total, Last(leaderboard.cpsa) AS cpsa, Last(leaderboard.rbss) AS rbss...

Part and Inventory Search

Back
Top