How do I SQL query to select the sum of column of specific val

Question

1.00/5 (2 votes)

See more:

ID Vehicle_Color
1234 Red
2345 Blue
3456 Black
4567 Red
5678 White

How do I list just the red-colored cars?

What I have tried:

I've tried to use select count (distinct vehicle_color='red'

Posted 2-Jun-23 5:32am

Jose Cruz 2023

Updated 2-Jun-23 10:51am

Add a Solution

Comments

Dave Kreskowiak 2-Jun-23 15:32pm

You might also want to read up on the documentation for DISTINCT and SELECT WHERE clauses. You don't need DISTINCT to do this at all.

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Answer 1 · 2023-06-02T05:39:00

Solution 1

See SQL COUNT(), AVG() and SUM() Functions[^].

Posted 2-Jun-23 5:39am

Richard MacCutchan

OriginalGriff · Answer 2 · 2023-06-02T10:51:00

The general form of an SQL query is:

SQL

SELECT <columns list> FROM <Table name> WHERE <condition>

For example to find all the red cars you might use:

SQL

SELECT * FROM Cars WHERE Colour = 'Red'

So the first thing you need to do is use something like that to find all the records you are interested in.

When you can get them - and only them - you can use use an aggregate function as Richard has suggested in place of the columns list.

How do I SQL query to select the sum of column of specific val

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

How do I SQL query to select the sum of column of specific val

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us