Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2012
    Posts
    25

    Unanswered: Sorting Types in db2

    Hi, how many sorting types are available in db2, please provide solutin to me.






    Thanks and Regards
    Narasimha A

  2. #2
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    ..., how many sorting types are available in db2, ...
    What means "sorting types"?


    By the way,
    you can specify these items/expressions in ORDER BY claus
    Code:
    sort-key
    
    |--+-simple-column-name--+--------------------------------------|
       +-simple-integer------+   
       '-sort-key-expression-'
    Code:
    sort-key-expression
    
    An expression that is not simply a column name or an unsigned integer constant.
     The query to which ordering is applied
     must be a subselect to use this form of sort-key.
     The sort-key-expression cannot include
     a correlated scalar fullselect (SQLSTATE 42703)
     or
     a function with an external action (SQLSTATE 42845).
    Please see more details in
    order-by-clause

Posting Permissions

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