Using Count Condition

Question

i have a table consist of Truck Id & Mileage where Truck ID can be duplicated (trips). I want a query that shows the Max(mileage)-Min(Mileage) but only if the count of Truck Id > 1. Excuse me i am still a beginner in this world.

What did you try?

rbr94
– rbr94

2016-11-03 08:54:55 +00:00
Commented Nov 3, 2016 at 8:54 — rbr94
– rbr94, Commented Nov 3, 2016 at 8:54
Did our answers help you?

rbr94
– rbr94

2016-11-08 09:17:27 +00:00
Commented Nov 8, 2016 at 9:17 — rbr94
– rbr94, Commented Nov 8, 2016 at 9:17

Akshey Bhat · Accepted Answer · 2016-11-03 08:55:53Z

2

Select Max(mileage)-Min(Mileage) as diff, TruckID
from tableTruck
group by truckid
having count(truckid) > 1

Use this query

answered Nov 3, 2016 at 8:55

Akshey Bhat

8,6872 gold badges24 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

rbr94 · Accepted Answer · 2016-11-03 09:14:27Z

2

Try to use GROUP BY ... HAVING:

SELECT MAX(mileage)-MIN(Mileage), Truck_Id
FROM YourTable
GROUP BY Truck_Id
HAVING COUNT(Truck_id) > 1

A little tutorial with examples on the HAVING clause you find here: http://www.w3schools.com/sql/sql_having.asp

edited Nov 3, 2016 at 9:14

answered Nov 3, 2016 at 8:57

rbr94

2,2874 gold badges27 silver badges40 bronze badges

Collectives™ on Stack Overflow

Using Count Condition

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related