Each GROUP BY expression must contain at least one column that is not an outer reference

• sonyMadhu

  SSC Rookie

  Points: 26

  More actions

  October 8, 2011 at 1:07 am

  #390570

  Hi all,

  select * from [table_name]

  where Date_Signed in (select Date_Signed from [table_name] group by Date_Signed having COUNT(Date_Signed)>1)

  is giving error:

  Each GROUP BY expression must contain at least one column that is not an outer reference

  How can i achieve this?

• yubo1

  SSChasing Mays

  Points: 612

  More actions

  October 8, 2011 at 1:44 am

  #1392033

  HI where is the DDL,but you can try sql_code below anyway

  select * from [table_name] a

  where (select COUNT(1) from [table_name] b where a.Date_Signed=b.Date_Signed)>1