Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
275 views
in Technique[技术] by (71.8m points)

SQL Query to select one set when there are duplicates

enter image description here

SELECT REF_ID, MIN(SLA) FROM [SLA] WHERE [FIRST_DATE] > '2016-09-30' GROUP BY  [REF_ID]  

This will list the items with minimum SLA when there are duplicates

REF_ID    |    COUNT  
11    |    1  
12    |    1  
13    |    1  
14    |    2  

I would like to get the count of SLAs, Can someone provide a query for this please.

SLA    |    COUNT  
1    |    3  
2    |    1  
0    |    0  

Thanks

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

To get the number of SLAs:

select SLA, count(SLA) from table group by SLA

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

2.1m questions

2.1m answers

60 comments

57.0k users

...