Re: keeping duplicates with certain associated fields

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

Next message: Gregory A. Larsen: "Re: query for identity columns"
Previous message: Anith Sen: "Re: Search and replace text in the entire database?"
In reply to: neil: "keeping duplicates with certain associated fields"
Messages sorted by: [ date ] [ thread ]

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

Next message: Gregory A. Larsen: "Re: query for identity columns"
Previous message: Anith Sen: "Re: Search and replace text in the entire database?"
In reply to: neil: "keeping duplicates with certain associated fields"
Messages sorted by: [ date ] [ thread ]

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: foreign key constraint without database diagram
... Refer to SQL Server Books Online for more details for syntax & examples. ...
(microsoft.public.sqlserver.programming)
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: 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)