0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and amateur woodworkers

SELECT
    (SELECT COUNT(*) FROM Posts) AS [Posts Count], -- Количество строк в таблице Posts
    (SELECT COUNT(*) FROM Users) AS [Users Count], -- Количество строк в таблице Users
    CAST((SELECT COUNT(*) FROM Posts) AS BIGINT) * CAST((SELECT COUNT(*) FROM Comments) AS BIGINT) AS [Posts * Comments Count] -- Произведение количества строк в таблицах Posts и Comments

view current version

edited dec 3

created dec 3 jon.doe46476