TG: sql_for_qa/70

Какой из следующих SQL запросов вернет топ-5 наиболее часто встречающихся значений из колонки с названием "cat" таблицы "products"?

Anonymous Quiz

SELECT TOP 5 cat, COUNT() AS count FROM products GROUP BY cat ORDER BY count DESC;

SELECT cat, COUNT() AS count FROM products GROUP BY cat ORDER BY count DESC LIMIT 5;

SELECT cat, COUNT() AS count FROM products GROUP BY cat ORDER BY count DESC FETCH NEXT 5 ROWS ONLY;

SELECT cat, COUNT() AS count FROM products GROUP BY cat ORDER BY count DESC WHERE ROWNUM <= 5;

585 answered

Create: 2023-03-26
Last Update: 2025-07-01 22:02:23

BY SQL для тестировщика

Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/sql_for_qa/70

SQL для тестировщика Telegram | DID YOU KNOW?