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

    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

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

    Continue Reading...