Home Forums SQL Server 2008 SQL Server 2008 - General how to avoid duplictae records of column in a table in a select query in this proc? RE: how to avoid duplictae records of column in a table in a select query in this proc?

  • November 16, 2012 at 3:47 am

    #1559714

    As company S1 has offices in UK,US and IN. how is SQL supposed to know that you want the US office instead of one of the others.

    Unless you specify an ORDER BY clause, you cannot guarantee that the data will always be returned in the same sequence so the results of the query may change even if the data does not.