SQL Query

[sathishkm21]

Hi,

I have a table consists of multiple company names.

Company Name Count

Advanced Micro Devices Inc	1
Avnet Inc	5
Avnet Inc	4
Avnet Inc	3
Avnet Inc	2
Avnet Inc	1
Capgemini Us Llc	2
Capgemini Us Llc	1
Cerner Corporation	1
Colgate-Palmolive Company	1
Compucom Systems Inc	1
Computer Sciences Corporation	1
Forsythe Solutions Group Inc	1
Forsythe Technology, Inc.	1
Hewlett-Packard Co	1
Hitachi Data Systems Corporation	8
Hitachi Data Systems Corporation	7
Hitachi Data Systems Corporation	6
Hitachi Data Systems Corporation	5
Hitachi Data Systems Corporation	4
Hitachi Data Systems Corporation	3
Hitachi Data Systems Corporation	2
Hitachi Data Systems Corporation	1

Need SQL query to get all the company having count less than 3

[ranman256]

select co, count from table where count < 3

[orange]

Try

SELECT COUNT([Company Name]), [Company Name]
FROM YourTableNameHERE
GROUP BY [Company Name]
HAVING COUNT([Company Name]) <3
ORDER BY COUNT([Company Name]);