sequelize 别名排序

User.findAll({
    attributes: [
        'User.username',
        [sequelize.literal('(SELECT COUNT(*) FROM Posts WHERE Posts.userId = User.id)'), 'PostCount']
    ],
    order: [[sequelize.literal('PostCount'), 'DESC']]
});
posted @ 2019-11-14 09:47  xiguachaodan  阅读(999)  评论(0)    收藏  举报