General discussion

Locked

SQL Query

By andres ·
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.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

SQL Query

by TimTheToolMan 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.

Collapse -

SQL Query

by andres In reply to SQL Query

Poster rated this answer

Collapse -

SQL Query

by andres In reply to SQL Query

This question was closed by the author

Back to Networks Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums