An toàn dữ liệu trong SQL Server là gì? Đâu là phương án đúng trong các phương án dưới đây:

Select * From Persons WHERE FirstName='%a%'

Select * From Persons WHERE FirstNameLIKE %

Select * From Persons WHERE FirstName=’a’

Select * From Persons WHERE FirstName='a%'

CREATE DB

CREATE TABLE  

CREATE DATABASE TAB

CREATE DATABASE TABLE

DISTINCTIVE

UNIQUE

DISTINCT

DIFFERENT

SELECT ID_CUAHANG, SUM(DOANH_THU) FROM BANHANG GROUP BY ID_CUAHANG HAVING SUM(DOANH_THU) > 5000;

SELECT ID_CUAHANG, SUM(DOANH_THU) FROM BANHANG GROUP BY ID_CUAHANG HAVING DOANH_THU > 5000;

SELECT ID_CUAHANG, SUM(DOANH_THU) FROM BANHANG WHERE SUM(DOANH_THU) > 5000 GROUP BY ID_CUAHANG;

SELECT ID_CUAHANG, SUM(DOANH_THU) FROM BANHANG WHERE DOANH_THU > 5000 GROUP BY ID_CUAHANG;

SELECT * FROM KETQUA_KIEMTRA WHERE HO_SV LIKE 'L%'; 

SELECT * FROM KETQUA_KIEMTRA WHERE HO_SV LIKE 'L'; 

SELECT * FROM KETQUA_KIEMTRA WHERE HO_SV = 'L'; 

SELECT * FROM KETQUA_KIEMTRA WHERE HO_SV <> 'L';

95

85

100

78