tyson記事本

Google & man(Unix) are your best friends!

Skip to: Content | Sidebar | Footer

Date: January 12th, 2005

取重複值

12 January, 2005 (12:32) | SQL | By: tyson

select * from global_dept group by dept_no,dept_name having count(dept_name)>1