I tried to do the same thing myself and finally this is how I worked it out :
SELECT
rowCode <---- (Some unique numeral key)
firstname,lastname,address1 <---- distinct columns
plandate,plandate2 <---- non distinct columns
FROM table
WHERE rowCode IN (SELECT Min(rowCode) FROM table GROUP BY firstname,lastname,address1)
ORDER by firstname
This will return unique values for your distinct columns and will the first (min) value of your non distinct columns .
---------------------------------------------------
Actually in your case, because your 'non distinct' column has a 'date' type, you can solve it more easily by using the following code :
SELECT Bank, Account, Note, MAX(PlanDate)
FROM table
GROUP BY Bank, Account, Note
1Expand
SQL Server programming Select DISTINCT columns along with a NON-DISTINCT column
more fromwww.eggheadcafe.com
SQL Injection SubSelects and IF Statements
in list: SQL Injection Articles
more fromferruh.mavituna.com
Record Locater for SQL Injection
Great script to found password/user etc. column and tables in SQL Injections (for MS SQL)
in list: SQL Injection Articles
more fromferruh.mavituna.com
SQL SERVER - Simple Example of WHILE Loop With CONTINUE and BREAK Keywords « Journey to SQL Authority with Pinal Dave
more fromblog.sqlauthority.com
Notation: * = Private bookmark and comment|… = Clipping [?] | … = Public highlight [?]
F M's Related Tags
Selected tags
Related tags
