数据如表所示:
HDSJ_ID HDSJ_YPPH
1 #8-9-5
2 #8-9-9
3 #8-9-5
4 #6-5
5 #8-9-9
6 #6-5现在我要提到这样的:请问怎么写SQL语句?因为我写的要么就是得出不重复的但排序不对,排序对的又变成重复的
HDSJ_YPPH
#6-5
#8-9-9
#8-9-5 这是我写的SQL语句:这个得到不重复的但排序不是我想要的:
select top 6 HDSJ_YPPH from TB_HYDSJ where HYDSJ_TP = 4 group by HDSJ_YPPH
这种排序是我想要的但变成重复的记录:
select top 6 HDSJ_YPPH,HDSJ_ID from TB_HYDSJ where HYDSJ_TP = 4 group by HDSJ_YPPH,HDSJ_ID order by HDSJ_ID desc
HDSJ_ID HDSJ_YPPH
1 #8-9-5
2 #8-9-9
3 #8-9-5
4 #6-5
5 #8-9-9
6 #6-5现在我要提到这样的:请问怎么写SQL语句?因为我写的要么就是得出不重复的但排序不对,排序对的又变成重复的
HDSJ_YPPH
#6-5
#8-9-9
#8-9-5 这是我写的SQL语句:这个得到不重复的但排序不是我想要的:
select top 6 HDSJ_YPPH from TB_HYDSJ where HYDSJ_TP = 4 group by HDSJ_YPPH
这种排序是我想要的但变成重复的记录:
select top 6 HDSJ_YPPH,HDSJ_ID from TB_HYDSJ where HYDSJ_TP = 4 group by HDSJ_YPPH,HDSJ_ID order by HDSJ_ID desc
解决方案 »
- 软件运行偶尔突然出错,然后退出
- 再追加100分,关于这段代码哪里需要修改?一共200分...
- 文本导出时,不能换行,请高手给于分析原因
- 这个表的问题怎么解决那??? 大家来看看!
- 一段登陆验证服务器需要的加密解密过程,c语言的东西,帮忙翻译成delphi的,要注释
- Tstring的空为'';Tpoint的空为nil;那么Tdatetime的空用什么表示?
- 2000与98的兼容问题
- 怎样用delphi存取Web的access库!
- 请问Delphi中,怎样定义和使用静态的二维数组?
- DELPHI 5 不能自定义控件问题
- 如何让Edit或DBEdit文字上下居中?谢谢!
- twebbrowser调用URL后,帐号二次登录,变成同一个帐号的内容了
DECLARE @T TABLE (cola INT,colb VARCHAR(32))
INSERT INTO @T
SELECT 1,'#8-9-5' UNION ALL
SELECT 2,'#8-9-9' UNION ALL
SELECT 3,'#8-9-5' UNION ALL
SELECT 4,'#6-5' UNION ALL
SELECT 6,'#8-9-9' UNION ALL
SELECT 7,'#6-5' UNION ALL
SELECT 8,'#8-9-9' UNION ALL
SELECT 9,'#8-9-7'select distinct min(cola) cola,colb from @t group by colb order by cola
DECLARE @T TABLE (cola INT,colb VARCHAR(32))
INSERT INTO @T
SELECT 1,'#8-9-5' UNION ALL
SELECT 2,'#8-9-9' UNION ALL
SELECT 3,'#8-9-5' UNION ALL
SELECT 4,'#6-5' UNION ALL
SELECT 6,'#8-9-9' UNION ALL
SELECT 7,'#6-5' UNION ALL
SELECT 8,'#8-9-9' UNION ALL
SELECT 9,'#8-9-7'select * from @T--result
/*
1 #8-9-5
2 #8-9-9
3 #8-9-5
4 #6-5
6 #8-9-9
7 #6-5
8 #8-9-9
9 #8-9-7
*/select distinct min(cola) cola,colb from @t group by colb order by cola--result
/*
1 #8-9-5
2 #8-9-9
4 #6-5
9 #8-9-7
*/select top 2 t.*
from (select distinct min(cola) cola,colb from @t group by colb ) t
order by t.cola-result
/*
1 #8-9-5
2 #8-9-9
*/
#6-5 最小
#8-9-9 最大
#8-9-5 中间