Snippets of the day – Friday, October 11, 2013

Posted on Posted in Snippets


Here are some of the most recently published snippets!

Removing Duplicated rows from table

Let’s use ROW_NUMBER() to purge tables from duplicated data.
You need to identify which set of columns are the unique key and then apply PARTITION over them.
Thanks to Stefan Krzywicki.

Open the snippet

Author:    cghersi

How to read and parse a txt file in python

This code shows how to read a txt file and parse the data

Open the snippet

Author:    lbottaro

Leave a Reply

Your email address will not be published. Required fields are marked *