Test:sql

CREATE TABLE `more` (
  `name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of more
-- ----------------------------
INSERT INTO `more` VALUES ('a');
INSERT INTO `more` VALUES ('b');
INSERT INTO `more` VALUES ('c');
INSERT INTO `more` VALUES ('d');

select * from more a,more b where a.`name`>b.`name`