T
T
tolsor2018-05-07 00:31:21
MySQL
tolsor, 2018-05-07 00:31:21

How to write a sql query that counts the number of different cells?

You need to count the number of different apartments.
This is how all apartments are considered, even the same:

SELECT COUNT(`kvart`) AS 'Количество квартир' FROM `dannie`

Answer the question

In order to leave comments, you need to log in

1 answer(s)
K
Konstantin, 2018-05-07
@tolsor

SELECT COUNT(DISTINCT 'kvart') AS 'kol-vo raznych' FROM 'dannie'

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question