SQL Archive

  • How to convert MySQL queries with LIMIT keyword to MS SQL query with TOP keyword.

    Running MySQL queries with LIMIT on MS SQL

    Posted on January 30, 2011 | 5 Comments
    How to convert MySQL queries with LIMIT keyword to MS SQL query with TOP keyword.

    Continue Reading...

  • SQL query sample to find rows with same values in particular column. Good to find duplicates in a table.

    SQL: Finding duplicates in table

    Posted on January 28, 2011 | No Comments
    SQL query sample to find rows with same values in particular column. Good to find duplicates in a table.

    Continue Reading...