DROP TABLE IF EXISTS `sales`;

CREATE TABLE `sales` (

  `empid` VARCHAR(10) NOT NULL,

  `mgrid` VARCHAR(10) NOT NULL,

  `qty` INT(11) NOT NULL,

  PRIMARY KEY (`empid`)

) ENGINE=INNODB DEFAULT CHARSET=utf8;

/*Data for the table `sales` */

INSERT  INTO `sales`(`empid`,`mgrid`,`qty`) VALUES ('A','Z',300),('B','X',100),('C','X',200),('D','Y',200),('E','Z',250),('F','Z',300),('G','X',100),('H','Y',150),('I','X',250),('J','Z',100),('K','Y',200);

SELECT empid,(

    SELECT COUNT(*) FROM sales T1 WHERE T1.empid <= T2.empid

) AS rownum

 FROM sales T2;

 SELECT empid,qty,(

    SELECT COUNT(*) FROM sales T1 WHERE T1.qty < T2.qty OR (T1.qty=T2.qty AND T1.empid <= T2.empid)

 ) AS rownum

 FROM sales T2

 ORDER BY qty,empid;

CREATE TABLE `t` (

    `a` CHAR (3)

);

INSERT INTO `t` (`a`) VALUES('X');

INSERT INTO `t` (`a`) VALUES('X');

INSERT INTO `t` (`a`) VALUES('X');

INSERT INTO `t` (`a`) VALUES('Y');

INSERT INTO `t` (`a`) VALUES('Y');

INSERT INTO `t` (`a`) VALUES('Z');

SELECT n.a,n.a+smaller AS rownum, C.a FROM(

    SELECT a, COUNT(*) AS countt, (

     SELECT COUNT(*) FROM t AS B WHERE B.a < A.a

    ) AS smaller

    FROM t AS A

    GROUP BY a

) AS C, nums AS n

WHERE n.a <= countt