Nice 💪

mình muốn custom lại response khi bảo trì thì làm như nào ?

Cảm ơn bạn đã rep. Mình sẽ tìm hiểu thêm các thông tin bạn gợi ý

Anh có làm về trích xuất thông tin từ căn cước công dân chưa ạ? Nếu có thì cho em tham khảo với.

Mình xin chia sẻ thêm web học lập trình mà mình rất tâm đắc https://vntalking.com

Rất hữu ích ạ

Triệu tim vì bài viết

Bài hay quá ạ

Mình mới nghĩ ra được câu truy vấn : select * from ( select *, RANK() over (PARTITION BY company_id order by countUser desc) as rank_no from ( select *, count(user_id) as countUser from orders where created_at between SUBDATE(CURDATE(), INTERVAL 5 DAY) AND CURDATE() group by company_id, user_id order by countUser desc ) as datasource ) as test where rank_no = 1 ;

Many thanks for this post. Send a cup of coffee to master HuyDQ ☕️☕️☕️

@alitonia Mình càm ơn ạ

hi a, cho e xin link repo github e xem cho dễ với ạ

@ThoaiDao vậy mình cũng khá đợi phần end vì mình biết nếu ở ver node bh vẫn làm như bạn thì chắc chắn sẽ k chạy đc =))

https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam

https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://duankhudothivicam.net/ https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam https://www.facebook.com/duankhudothivicam

Bác có source không em xin với ạ. Em xin cảm ơn ạ

with t_1 as( select user_id, count(user_id) as order_count, company_id from order_group where DATEDIFF(day, GETDATE(), order_group.created_at) < 5 group by user_id, company_id ), t_2 as ( select *, RANK() OVER (PARTITION BY t_1.company_id ORDER BY t_1.order_count) as ranking
from t_1 ) select * from t_2 WHERE ranking <= 5 order by company_id, ranking;

Cái này mình code bằng ms sql. Nếu mà nhiều ngươif cùng số order thì sẽ cùng rank, ví dụ 3 người cùng xếp thứ 4 thì sẽ hiện cả 3 ngưòi đó.

Ví dụ ở đây có 5 công ty, và mỗi cty có nhiều nhân viên order , thì yêu cầu ở đây cần lấy ra users có số lượng order nhiều nhất của mỗi cty, thì cần lấy ra 5 user có số lượng order nhiều nhất của mỗi cty.

tại sao ng ta ko có chế độ kết hợp read committed và repeatable read để tránh phantom read (chỉ đọc dữ liệu đã commit và repeatable). để thay thế cho serializable sẽ bị lỗi khi có transaction lồng nhau.

Tốt nhất vẫn nên bắt tay vào code để có thể hiểu được cụ thể nhất bác nhé.