按创建日期查找SQL表和组中的重复值[关闭]

3 回答

• 1

  SELECT   ORDER_NUMBERS, count(*)
  FROM     YourTableName
  GROUP_BY ORDER_NUMBERS
  HAVING   count(*) > 1
  ORDER BY CREATION_DATE
  

  回复于 2024-05-02T23:15:33+08:00
• 0

  select ORDERS_NUMBERS,CREATION_DATE,count(*)
  from
  table
  group by ORDERS_NUMBERS,CREATION_DATE
  order by CREATION_DATE desc 
  having count(*) > 1
  

  回复于 2024-05-02T23:15:33+08:00
• 0

  select 
  t.orders_numbers, 
  t.creation_date
  
  from table t
  group by t.orders_numbers, 
  t.creation_date
  having (count (*) >1)
  ;
  

  回复于 2024-05-02T23:15:33+08:00