Find the difference between the total number of city entries in the table and the number of distinct city entries in the table.
Answers
Answered by
65
Answer:
The query that shows the difference between the total number of city entries in the table and the number of distinct city entries in the table is following.
SELECT COUNT (CITY) – COUNT (DISTINCT CITY) FROM STATION; Here STATION is the table name and by using SELECT all the possible entries can be displayed.
Answered by
3
Answer:
select count(CITY)- count(distinct CITY) from STATION
Explanation:
Similar questions