Prev: SQL syntax (part 2)
Next: SQL optimisation, stop the sub query as soon as an error is found
From: Rob on 12 Nov 2009 12:53
That worked! Thank you so much. Great idea...it never occurred to me to use the MAX function with a string.

Best,
Rob



Plamen Ratchev wrote:

You can do:SELECT PersonID, MAX(IMadd), MAX(EmailAdd), MAX(Phone)FROM ...
11-Nov-09

You can do:

SELECT PersonID, MAX(IMadd), MAX(EmailAdd), MAX(Phone)
FROM ...
GROUP BY PersonID;


--
Plamen Ratchev
http://www.SQLStudio.com

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
Refactoring with the Parameterized Factory Pattern
http://www.eggheadcafe.com/tutorials/aspnet/345d6935-5ddd-4c03-8f3e-790afdea5895/refactoring-with-the-para.aspx
 | 
Pages: 1
Prev: SQL syntax (part 2)
Next: SQL optimisation, stop the sub query as soon as an error is found