كيفية احتساب اكثر حقل موجود في جدول

يمكنك إستخدام:

SELECT id, COUNT(id) AS 'Sold' FROM product_sales GROUP BY id ORDER BY COUNT(id) DESC;

أو إذا كنت فقط تريد الترتيب بدون عدد المبيعات:

SELECT id FROM product_sales GROUP BY id ORDER BY COUNT(id) DESC;

مثال:

IF OBJECT_ID('product_sales') IS NOT NULL DROP TABLE product_sales;

CREATE TABLE product_sales (
    id INT NOT NULL,
);
 
INSERT INTO product_sales VALUES(2);
INSERT INTO product_sales VALUES(4);
INSERT INTO product_sales VALUES(5);
INSERT INTO product_sales VALUES(7);
INSERT INTO product_sales VALUES(5);
INSERT INTO product_sales VALUES(6);
INSERT INTO product_sales VALUES(5);
INSERT INTO product_sales VALUES(1);
INSERT INTO product_sales VALUES(6);
INSERT INTO product_sales VALUES(2);
INSERT INTO product_sales VALUES(2);
 
SELECT id, COUNT(id) AS 'Sold' FROM product_sales GROUP BY id ORDER BY COUNT(id) DESC;

SELECT id FROM product_sales GROUP BY id ORDER BY COUNT(id) DESC;

بالنسبة لأكبر واحد أو أكبر ثلاثة أضف TOP 1 أو TOP 3 بعد SELECT:

SELECT TOP 1 id FROM product_sales GROUP BY id ORDER BY COUNT(id) DESC;

SELECT TOP 3 id FROM product_sales GROUP BY id ORDER BY COUNT(id) DESC;