Re: keeping duplicates with certain associated fields

From: Anith Sen (anith_at_bizdatasolutions.com)
Date: 05/20/04


Date: Thu, 20 May 2004 15:04:41 -0500

Use MIN() function on the column code with a GROUP BY in your SELECT
statement. Refer to SQL Server Books Online for syntax of a SELECT statement
in t-SQL.

-- 
Anith


Relevant Pages

  • Re: sp_password
    ... You can find the syntax for xp_cmdshell in SQL Server Books Online or at ... Technical Writer, SQL Server Books Online ... "Leon Parker" wrote in message ...
    (microsoft.public.sqlserver.security)
  • Re: Column alias in Select with Case
    ... Also, refer to ... SQL Server Books Online for the correct syntax for CASE. ...
    (microsoft.public.sqlserver.programming)
  • Re: foreign key constraint without database diagram
    ... Refer to SQL Server Books Online for more details for syntax & examples. ...
    (microsoft.public.sqlserver.programming)
  • Re: sql functions
    ... Refer ... to SQL Server Books Online for more details on its usage. ...
    (microsoft.public.sqlserver.programming)
  • Re: Using variable for INT in SELECT TOP...
    ... Because it is not the correct T-SQL syntax. ... topic SELECT in SQL Server Books Online, ... refer to similar posts and responses in the google ...
    (microsoft.public.sqlserver.programming)