Cơ sở dữ liệu ‘‘QuanLyTuyenSinh’’có bảng: DiemKhoiA(SoBaoDanh Nvarchar(50), DiemToan Float, DiemLy Float, DiemHoa Float, DiemUuTien Float, TongDiem Float, KetQua Nvarchar(50)) .Câu

35/40

Cơ sở dữ liệu ‘‘QuanLyTuyenSinh’’có bảng: DiemKhoiA(SoBaoDanh Nvarchar(50), DiemToan Float, DiemLy Float, DiemHoa Float, DiemUuTien Float, TongDiem Float, KetQua Nvarchar(50)) .Câu lệnh cho biết với mỗi loại tổng điểm có bao nhiêu thí sinh?

SELECT TongDiem, count() FROM DiemKhoiA GROUP BY TongDiem

SELECT TongDiem, count() FROM DiemKhoiA WHERE TongDiem = count(TongDiem)

SELECT TongDiem, count(*) FROM DiemKhoiA WHERE TongDiem

SELECT count(TongDiem) FROM DiemKhoiA

Giải thích

Chọn đáp án A