Re: How to query non mutiple rows in one cuolumn?

From: Hugo Kornelis (hugo_at_pe_NO_rFact.in_SPAM_fo)
Date: 06/04/04

  • Next message: Nikhil: "how do i create a view within a procedure that uses a variable defined in the procedure" 
    Date: Fri, 04 Jun 2004 23:28:58 +0200

    On Fri, 4 Jun 2004 11:24:53 -0700, new wrote:

    >I have one column name "pbulishID", I need retrun the row
    >only one publishID, not mutiple publishID.
    >Thanks all reply.

    SELECT DISTINCT publishID
    FROM MyTable

    Best, Hugo 

    -- 
(Remove _NO_ and _SPAM_ to get my e-mail address)
  • Next message: Nikhil: "how do i create a view within a procedure that uses a variable defined in the procedure"