假设表名字是personseleect s1.id,s1.name,s1.age,s2.id,s2.name,s2.age,min(abs(s1.age-s2.age)) as difference fromperson s1,person s2 where s1.id!=s2.id order by s1.id;把不同姓名的数据对应成一组数据,去年龄差的绝对值,然后取绝对值的最小值,输出者俩人的信息就OK了,我的是mysql数据库,对应你的数据库改一下格式一定好使。...
CREATE TABLE tes(ID INT,age INT) ;INSERT INTO tes(ID,age)VALUES(1001,10);INSERT INTO tes(ID,age)VALUES(1002,20);INSERT INTO tes(ID,age)VALUES(1003,13);INSERT INTO tes...