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é.

Cám ơn tác giả, bài viết rất bổ ích

• Một số đoạn bị lỗi chính tả anh ơi
  • xử dụng -> sử dụng
• Chữ "kết luận" ở cuối chưa viết hoa ạ

Mình xài theme random nha bạn ôi

Đoạn cuối mình nghĩ tổng quát hơn là: Không nên dùng index cho các cột có số lượng lớn các giá trị trùng nhau, chứ không riêng gì NULL.

nai xừ :v

Anh có thể nói kỹ hơn về thuật toán phần tái cấu trúc bảng để đưa ra file excel/docx được không ạ?

@binchanhkun99 a cũng hay vậy đó e

Code viết tay 1 lần thôi, các lần khác nếu giống thì copy paste, vấn đề làm sao biết copy chỗ nào paste chỗ nào.

A nghĩ e cần thêm rất nhiều thực hành để nâng vào trình độ và để nó "hằn" vào trong đầu những thứ như vậy

Mình làm đến bước build aar xong. Bị lỗi này. Ad check giúp mình với.

Sau khi add, nhấn Sync

String storageUrl = System.env.FLUTTER_STORAGE_BASE_URL ?:
        "https://storage.googleapis.com"
repositories {
    maven {
        url '/Users/vang.ta/Documents/VangThao/Sameple-Intergrated/sample-android/my_flutter/build/host/outputs/repo'
    }
    maven {
        url "$storageUrl/download.flutter.io"
    }
}

Lỗi:

A problem occurred evaluating project ':app'. Build was configured to prefer settings repositories over project repositories but repository 'maven' was added by build file 'app/build.gradle'