Day 7: DISTINCT In SQL

[Muhammad Hussnain]

SELECT COUNT([Departure Station]) as Total_Number_Of_Departure_Stations

FROM railway

SELECT COUNT(DISTINCT[Departure Station]) as Total_Different_Number_Of_Departure_Stations

FROM railway

SELECT COUNT([Departure Station]) - COUNT(DISTINCT[Departure Station]) as Total_Difference_Of_Departure_Stations

FROM railway

Today's Query Solution

Comment deleted

[IslamabadDataGuy]

You can also check unique transaction or unique customers at a specific stations using a where statement and distinct transaction id