如何在sql字段中获取频繁重复的值.. [英] how to get frequently repeated values in sql field..

问题描述

我有一张桌子，我想在dcr中取最大次数重复值并留下两列..请告诉我非常紧急

I have one table i want to take maximum times repeated value in dcr and leave both column..pls tell me very urgent

type	fscode		cr	leave	flag	
1		MSR042		2	2		0
1		MSR020		2	2		0
3		ZSM010		25	25		0
1		MSR086		2	2		0
1		MSR229		2	2		0
1		MSR150		2	2		0
1		MSR088		2	2		0
1		MSR258		2	2		0
2		ASM018		2	2		0
1		MSR228		2	2		0
1		MSR074		2	2		0
1		MSR241		2	2		0
1		MSR187		2	2		0
2		ASM008		2	2		0
2		ASM014		2	2		0
1		MSR105		2	2		0
1		MSR050		2	2		0
1		MSR256		2	2		0
1		MSR212		2	2		0
1		MSR159		2	2		0
1		MSR209		7	2		0
2		ASM019		2	2		0
1		MSR237		2	2		0
1		MSR265		2	2		0
1		MSR051		5	2		0
2		ASM009		2	2		0
2		ASM028		2	2		0
1		MSR151		2	2		0
1		MSR017		2	2		0
1		MSR286		25	25		0

推荐答案

以下查询返回最高值 dcr 和离开 fields。

Below query returns the highest value of dcr and leave fields.

SELECT [type], MAX(dcr) AS MaxOfDcr, MAX(leave) AS MaxOfLeave
FROM TableName
GROUP BY [type]

如果你想得到别的东西，请告诉我。

If you want to get something else, please let me know.

SELECT MAX(CountOfDcr) AS MaxCountOfDcr, MAX(CountOfLeave) AS MaxCountOfLeave
FROM(
    SELECT dcr, COUNT(dcr) AS CountOfDcr, leave, COUNT(leave) AS CountOfLeave
    FROM TableName
    GROUP BY dcr, leave
) AS T

[/ EDIT]

[/EDIT]

这篇关于如何在sql字段中获取频繁重复的值..的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！