Join or sign in Register for your free TechRepublic membership or if you are already a member, sign in using your preferred method below. Use Your Email Use FacebookUse Linkedin

SQL Query

Locked

How can i build the sql query for checking the duplicate value in the same column and join in a single query?

Example:
ColumnA = Company Name
ColumnB = Employee number

ColumnA has 3 ACME COMPANY record, each one has 67, 89 and 102 employees, the result must be:

ACME COMPANY, 258 employees.

Topic

SQL Query

In reply to SQL Query

Hi,

Here is an example that you should be able to use to solve your problem….

http://www.w3schools.com/sql/sql_functions.asp

(remove spaces from the above URL)

The site’s not too bad in general, too!

Cheers,
Tim.

SQL Query

In reply to SQL Query

Poster rated this answer

SQL Query

In reply to SQL Query

This question was closed by the author

[Author]

Replies