Loading ...
Sorry, an error occurred while loading the content.
 

Re: [SQLQueriesNoCode] FIND OUT THE DUPLICATE VALUES

Expand Messages
  • Surya Ganesh
    Hi, Check out this: select * from table1 a where a.rowid (select min(b.rowid) from table1 b where a.col_pk1=b.col_pk1 and a.col_pk2=b.col_pk2); I am sure this
    Message 1 of 3 , Sep 29, 2007
      Hi,
      Check out this:
      select * from table1 a
      where a.rowid>(select min(b.rowid)
      from table1 b
      where a.col_pk1=b.col_pk1
      and a.col_pk2=b.col_pk2);

      I am sure this will work for deleting duplicate rows...

      gethari_tng <haribabubala@...> wrote:
      HI FRDS WRITE A QUERY TO FIND OUT DUPLICATE VALUES






      ur Purpose On Earth Is Not To Get Used To The Dark But To Shine As Lights...Live Every Second


      Surya Ganesh,
      Final BE CSE,
      PSG Tech,
      Coimbatore.


      ---------------------------------
      Building a website is a piece of cake.
      Yahoo! Small Business gives you all the tools to get online.

      [Non-text portions of this message have been removed]
    Your message has been successfully submitted and would be delivered to recipients shortly.