mysql 发帖数最多_写出发帖数最多的前几条记录

因为面试题中经常被问到找出发帖数最多的几个用户的记录 后来回家测试后记录下

user.sql

/*

Navicat Premium Data Transfer

Source Server : 33.10

Source Server Type : MySQL

Source Server Version : 50556

Source Host : 192.168.33.10:3306

Source Schema : test

Target Server Type : MySQL

Target Server Version : 50556

File Encoding : 65001

Date: 22/02/2019 16:57:01

*/

SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------

-- Table structure for user

-- ----------------------------

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`name` varchar(255) DEFAULT NULL,

`create_time` datetime DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=136 DEFAUL