help in script

[160475]

dears,

good day!! 

i have a table named table1 where it shows 

date,               employee#,    transaction# 

1/1/2022          5656                 123

2/1/2022           6565                 321 

and i would like to write sql script where employee done 2 transaction in same day 

for example transaction numbers are 123 and 321 

can anyone help 

thank you!! 

[jaweher899]

Hi, here's a community for powerbi and not sql,

Please try 

SELECT employee# FROM table1 GROUP BY employee#, DAy(date) HAVING COUNT(transaction#) >= 2;