A watch has two fields, one of the fields,


If such written
Select FT. Count the from File_Type FT where FT. TypeID IN (' TY2020522945155 ', 'TY20205192212626) Group By FT. Count

So will appear the figure 2, the above will also come out together,
Figure 1 but I just want to query,
How to write?

CodePudding user response:

Analysis of the feeling that cannot be achieved,

CodePudding user response:

Didn't know what you mean

CodePudding user response:

Select FT. Count, the Count (*) from File_Type FT where FT. TypeID IN (' TY2020522945155 ', 'TY20205192212626) Group By FT. Count
Having the Count (*) & gt; 1

CodePudding user response:

You don't share group by addition polymerization means what? To the weight?

CodePudding user response:

Having a Count (Count) & gt; 1

CodePudding user response:

 select FT. Count 
The from File_Type FT 
Where FT. TypeID IN (' TY2020522945155 ', 'TY20205192212626) 
Group By FT. Count 
Having a count (distinct FT. TypeID)=2 

CodePudding user response:

Select FT. Count the from File_Type FT where FT. TypeID IN (' TY2020522945155 ', 'TY20205192212626)
And FT. Count like '% 2304'
Group By FT. A count