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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by jjtrap
-
Using MAX Function and return row other data from the Max Value
Thank you soo much! That second query helped out a lot! -
Using MAX Function and return row other data from the Max Value
Hi everyone, I'm new to this site and SQL, so I apologize if I repeat this question. Within MS SQL 2000, I want to run a simple query to return the maxium value of the column col2. I run: SELECT Max(Table1.Col2) AS MaxOfCol2, Table1.Linker FROM Table1 GROUP BY Table1.Linker; And I get : Max...
