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

RE: [SQLQueriesNoCode] How to delete repeated data from a table?

Expand Messages
  • BESHOUY GERGES
    try select distinct Name Sal John Warner wrote: Happns to us all. I kept trying to figure out why the UI at 15seconds was so
    Message 1 of 10 , Mar 7 8:16 AM
    • 0 Attachment
      try select distinct Name Sal

      John Warner <john@...> wrote: Happns to us all. I kept trying to figure out why the UI at 15seconds
      was so different, finally after several searches it dawned on me.

      John Warner

      > -----Original Message-----
      > From: SQLQueriesNoCode@yahoogroups.com
      > [mailto:SQLQueriesNoCode@yahoogroups.com] On Behalf Of Michael Weiss
      > Sent: Monday, March 05, 2007 6:55 PM
      > To: SQLQueriesNoCode@yahoogroups.com
      > Subject: RE: [SQLQueriesNoCode] How to delete repeated data
      > from a table?
      >
      >
      > Ooh Good catch, John! Thanks! I didn't even notice the typo...
      >
      > Michael
      >
      >
      >
      > _____
      >
      > From: SQLQueriesNoCode@yahoogroups.com
      > [mailto:SQLQueriesNoCode@yahoogroups.com] On Behalf Of John Warner
      > Sent: Monday, March 05, 2007 3:06 PM
      > To: SQLQueriesNoCode@yahoogroups.com
      > Subject: RE: [SQLQueriesNoCode] How to delete repeated data
      > from a table?
      >
      >
      >
      > Note it is:
      > www.15seconds.com
      >
      > Note the "o" between "c" and "n". Makes all the difference in
      > the world to the help you will get.
      >
      > The para-site is a waste of your time
      >
      > John Warner
      >
      > > -----Original Message-----
      > > From: SQLQueriesNoCode@yahoogroups.com
      > <mailto:SQLQueriesNoCode%40yahoogroups.com>
      > > [mailto:SQLQueriesNoCode@yahoogroups.com
      > <mailto:SQLQueriesNoCode%40yahoogroups.com> ] On Behalf Of
      > Michael Weiss
      > > Sent: Monday, March 05, 2007 5:55 PM
      > > To: SQLQueriesNoCode@yahoogroups.com
      > <mailto:SQLQueriesNoCode%40yahoogroups.com>
      > > Subject: RE: [SQLQueriesNoCode] How to delete repeated data
      > > from a table?
      > >
      > >
      > > Try www.15secnds.com <http://www.15secnds.com/
      > <http://www.15secnds.com/> > - there is
      > > an article there by David Penton which covers deleting dupe records.
      > >
      > > Regards,
      > >
      > > Michael
      > >
      > >
      > >
      > > _____
      > >
      > > From: SQLQueriesNoCode@yahoogroups.com
      > <mailto:SQLQueriesNoCode%40yahoogroups.com>
      > > [mailto:SQLQueriesNoCode@yahoogroups.com
      > <mailto:SQLQueriesNoCode%40yahoogroups.com> ] On Behalf Of Ved Prakash
      > > Sent: Monday, March 05, 2007 9:07 AM
      > > To: SQLQueriesNoCode@yahoogroups.com
      > <mailto:SQLQueriesNoCode%40yahoogroups.com>
      > > Subject: [SQLQueriesNoCode] How to delete repeated data
      > from a table?
      > >
      > >
      > >
      > > Hi,
      > >
      > > I have a problem. How to delete repeated data from a table?
      > > Can any body help me to out of the prob.
      > >
      > > Prob:
      > > I have a table Table1. There is no primary key. There is
      > > repeted data in the table1 e.g Table1 Data
      > > ----------------------------------------------------------
      > > Name Sal
      > > ----------------------------------------------------------
      > > A 3000
      > > B 2000
      > > B 2000
      > > C 1000
      > > C 1000
      > > C 1000
      > > A 3000
      > > D 5000
      > > B 2000
      > > ----------------------------------------------------------
      > > Now I have to write a query which will delete the repeated
      > > data. As for this example Output should be
      > >
      > > ----------------------------------------------------------
      > > Name Sal
      > > ----------------------------------------------------------
      > > A 3000
      > > B 2000
      > > C 1000
      > > D 5000
      > > ----------------------------------------------------------
      > > Thanks in Adv.
      > > Prakash
      > >






      ---------------------------------
      Don't get soaked. Take a quick peek at the forecast
      with theYahoo! Search weather shortcut.

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