0 votes
in General Knowledge by (557k points)
Find the difference between the total number of city entries in the table and the number of distinct city entries in the table.

1 Answer

0 votes
by (557k points)
 
Best answer
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.
Welcome to the Answerine , a great place to find, read and share your favorite questions and answers.
...