Forum Discussion

160475's avatar
160475
Helper I
3 years ago

help in script

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!! 

Need Help

1 Reply

  • jaweher899's avatar
    jaweher899
    Impactful Individual
    3 years ago

    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;