Tài liệu đang xem: Câu truy vấn Bài 1

use KHACHHANG;
-- yc1 --
select * from KhachHang;
-- yc2 --
select top 10 maKhachHang, hoVaTenLot, Ten, Email, dienThoai from KhachHang;
-- yc3 --
select maSanPham, tenSP, donGia*soLuong as 'Tiền Tồn Kho' from SanPham;
-- yc4 --
SELECT maKhachHang, hoVaTenLot + Ten as HoVaTen, diaChi FROM KhachHang
WHERE hoVaTenLot LIKE 'H%';
-- yc5 --
SELECT * FROM KhachHang WHERE diaChi LIKE '%DaNang%';
-- yc6 --
SELECT * FROM SanPham WHERE soLuong BETWEEN 100 AND 500;
-- yc7 --
SELECT * FROM HoaDon WHERE trangThai ='Chưa thanh toán'AND year(ngayMuaHang) = 2016 ;
-- yc8 --
SELECT * FROM HoaDon WHERE maKhachHang IN ('KH001', 'KH003', 'KH006');