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: Best way to kick out users from DB
    ... There is an ALTER DATABASE option with which you can set it to SINGLE_USER ... Refer to SQL Server Books Online for details. ...
    (microsoft.public.sqlserver.programming)
  • Re: sql functions
    ... Refer ... to SQL Server Books Online for more details on its usage. ...
    (microsoft.public.sqlserver.programming)