CODEWITHSUNDEEP
mysqlsqloracle-database
DilTeam
DilTeam

Reputation: 2661

Query works in Oracle by not in Mysql

This query works in Oracle:

select count(city) - count (distinct city) from station;

But doesn't work in MySQL. What's the MySQL equivalent of this query? At the risk of pointing out obvious, this query returns the 'difference' between 'total no. of cities' on the station table and number of distinct cities.

Upvotes: 0

Views: 42

Answers (1)

peterm
peterm

Reputation: 92795

It should work just fine if you remove space after second count

select count(city) - count(distinct city) from station;
                          ^

Here is a SQLFiddle

To use the name as a function call in an expression, there must be no whitespace between the name and the following “(” parenthesis character.

See 10.2.4 Function Name Parsing and Resolution

Upvotes: 6

Related Questions