Recontract Penalty Charges for all 3 telcos

Singtel

https://www.singtelshop.com/support/support.html

Customers shall be permitted to upgrade their mobile equipment upon expiry of twelve (12) months from the commencement of the Equipment Undertaking Agreement by paying a charge of either $300 (for iPhone & selected smartphones*) or $200 (for all other handsets) in addition to the prevailing price of the mobile equipment

M1

http://www.m1shop.com.sg/Redirect?nextpage=menuterms.jsp&n=Terms%20%26%20Conditions

Additional $100 and $300 applies on the phone offers for customer who have completed at least 11 months of their normal handset contract and/or iPhone handset contract respectively.

Starhub
http://www.starhub.com/support/mobile/faq/mobileservices/recontractpolicy.html

The prevailing Early Handset Upgrade Fee for non – iPhone contracted customers is at $200 and for iPhone contracted customers is $300 or otherwise stated.


in summary -

ST -
change to iPhone and selected smartphones - $300
other phones - $200

M1 -
Previous contract buy iPhone - $300
Previous contract buy other phones - $100

SH -
Previous contract buy iPhone - $300
Previous contract buy other phones - $200

Remove duplicates rows from a table?

SQL> DELETE FROM table_name A WHERE ROWID > (
2 SELECT min(rowid) FROM table_name B
3 WHERE A.key_values = B.key_values);