DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Select Distinct 1 state

  1. #1
    Join Date
    Nov 2000
    Posts
    74
    Can anyone tell me what the 1's in here refer to?

    CURSOR c_category is select distinct 1 state, 1 depth, category labels, null icon, category data
    from products
    order by category;


    Thanks for any assistance.

  2. #2
    Join Date
    Aug 2001
    Location
    Washington, USA
    Posts
    3

    Smile

    1 ref to table.fieldName i.e replace 1 with your suitable field name of a table.
    Pras :cool:

  3. #3
    Join Date
    Jan 2001
    Posts
    153
    IN THIS CURSOR...

    STATE AND DEPTH COLUMN WILL HAVE VALUE 1 AND ICON FIELD WILL HAVE NULL VALUES ETC..

    state, depth is an alais column name for 1
    labels is an alias column name for category
    icon is an alias column name for NULL
    data is an alias column for category.

    CURSOR c_category is select distinct 1 state, 1 depth, category labels, null icon, category data
    from products
    order by category;


    Vijay.s

  4. #4
    Join Date
    Nov 2000
    Posts
    74

    Thanks for the explanation

    Thanks for the assistance.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width