/*
Navicat MySQL Data TransferSource Server : localhost
Source Server Version : 60002
Source Host : localhost:3306
Source Database : huadiTarget Server Type : MYSQL
Target Server Version : 60002
File Encoding : 65001Date: 2010-10-27 11:02:40
*/SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `ljz`
-- ----------------------------
DROP TABLE IF EXISTS `ljz`;
CREATE TABLE `ljz` (
`record_id` int(11) NOT NULL AUTO_INCREMENT,
`order_no` varchar(20) DEFAULT NULL,
`gd_no` varchar(50) DEFAULT NULL,
PRIMARY KEY (`record_id`),
KEY `idx_t_gd_az_zp_cust_myd` (`order_no`,`gd_no`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=1462 DEFAULT CHARSET=utf8;-- ----------------------------
-- Records of ljz
-- ----------------------------
INSERT INTO `ljz` VALUES ('3', '100519132835001', 'HD0760WX0001');
INSERT INTO `ljz` VALUES ('5', '100519132835002', 'HD0760WX0001');
INSERT INTO `ljz` VALUES ('8', '100519132835003', 'HD0760WX0002');
INSERT INTO `ljz` VALUES ('7', '100519132835004', 'HD0760WX0003');
mysql 实现查找出1个gd_no 对应有1个以上的order_no值 的gd_no
结果如下
gd_no
HD0760WX0001
Navicat MySQL Data TransferSource Server : localhost
Source Server Version : 60002
Source Host : localhost:3306
Source Database : huadiTarget Server Type : MYSQL
Target Server Version : 60002
File Encoding : 65001Date: 2010-10-27 11:02:40
*/SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `ljz`
-- ----------------------------
DROP TABLE IF EXISTS `ljz`;
CREATE TABLE `ljz` (
`record_id` int(11) NOT NULL AUTO_INCREMENT,
`order_no` varchar(20) DEFAULT NULL,
`gd_no` varchar(50) DEFAULT NULL,
PRIMARY KEY (`record_id`),
KEY `idx_t_gd_az_zp_cust_myd` (`order_no`,`gd_no`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=1462 DEFAULT CHARSET=utf8;-- ----------------------------
-- Records of ljz
-- ----------------------------
INSERT INTO `ljz` VALUES ('3', '100519132835001', 'HD0760WX0001');
INSERT INTO `ljz` VALUES ('5', '100519132835002', 'HD0760WX0001');
INSERT INTO `ljz` VALUES ('8', '100519132835003', 'HD0760WX0002');
INSERT INTO `ljz` VALUES ('7', '100519132835004', 'HD0760WX0003');
mysql 实现查找出1个gd_no 对应有1个以上的order_no值 的gd_no
结果如下
gd_no
HD0760WX0001
select gd_no,count(*) from ljz group by gd_no having count(*) >1;
select gd_no,count(distinct(order_no)) from ljz group by gd_no having count(distinct(order_no)) >1;应该是这样。order_no也不可重复。