I have a SQL Server database in which I ran a query that collects the data about two different tournamnets and the number of people enrolled in the tournament. So for instance the output is:
Name of Tourney People enrolled Tourney 1 ----------- 7 Tourney 2 ----------- 8
After getting these two values, I want to be able to compare them and only show the information for the tournmanet that contains the highest number of people enrolled. Should all be in one query...how can I do this?