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

RE: [SQLQueriesNoCode] Unique Value help

Expand Messages
  • RAJASEKARAN S /NBP/INFOTECH/CHE
    hi Try using group by the particular column followed by HAVING COUNT(COLUMN_NAME) 1 bye ... From: Cyberdemon12 [mailto:cyberdemon12@yahoo.com] Sent:
    Message 1 of 3 , Mar 30, 2005
    • 0 Attachment
      hi
      
        Try using group by the particular column followed by HAVING
      COUNT(COLUMN_NAME) > 1
      
      bye
      
      
      -----Original Message-----
      From: Cyberdemon12 [mailto:cyberdemon12@...]
      Sent: Wednesday, March 30, 2005 12:09 PM
      To: SQLQueriesNoCode@yahoogroups.com
      Subject: [SQLQueriesNoCode] Unique Value help
      
      
      
      
      
      I'm in a Database Class, and I'm trying to write queries for a
      midterm, its too late now to get it right on the test, but I'd really
      like to know how to write this select query. the question (the only
      one I couldn;t figure out how to do) involves finding every value that
      occurs more than once in a column and I can't figure out how to do it.
      I know I can use the distinct command to get one of each value, but I
      can't seem to figure out how to only get the values that occur more
      than once (or even NOT the values that only occur once). If anyone has
      any ideas please reply.
      
      Thanks,
      -J
      
      
      
      
      
      
      
      
      
      Yahoo! Groups Links
      
      <*> To visit your group on the web, go to:
          http://groups.yahoo.com/group/SQLQueriesNoCode/
      
      <*> To unsubscribe from this group, send an email to:
          SQLQueriesNoCode-unsubscribe@yahoogroups.com
      
      <*> Your use of Yahoo! Groups is subject to:
          http://docs.yahoo.com/info/terms/
      
      
      
      
      

      3i Infotech

      Greetings!

      ICICI Infotech is now 3i Infotech.

      The e-mail addresses of the company's employees have been changed to <existing name>@.... You are requested to take note of this new e-mail ID and make use of the same in future

      "This e-mail message may contain confidential, proprietary or legally privileged information. It should not be used by anyone who is not the original intended recipient. If you have erroneously received this message, please delete it immediately and notify the sender. The recipient acknowledges that 3i Infotech or its subsidiaries and associated companies, (collectively "3i Infotech"), are unable to exercise control or ensure or guarantee the integrity of/over the contents of the information contained in e-mail transmissions and further acknowledges that any views expressed in this message are those of the individual sender and no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of 3i Infotech. Before opening any attachments please check them for viruses and defects."

    Your message has been successfully submitted and would be delivered to recipients shortly.