Re: SQL descending primary key

[GUY_HENZA@xxxxxxxxxxxxxx]

SELECT * FROM file ORDER BY 1 desc

Regards,

Guy



                                                                                                                                          
                      "Jeff Crosby"                                                                                                       
                      <jlcrosby@dilgardfoo        To:       "'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>           
                      ds.com>                     cc:                                                                                     
                      Sent by:                    Subject:  SQL descending primary key                                                    
                      midrange-l-bounces@m                                                                                                
                      idrange.com                                                                                                         
                                                                                                                                          
                                                                                                                                          
                      12/19/2007 12:59 PM                                                                                                 
                      Please respond to                                                                                                   
                      Midrange Systems                                                                                                    
                      Technical Discussion                                                                                                
                                                                                                                                          
                                                                                                                                          




All,

Is there no such thing as a _descending_ PRIMARY KEY in an SQL table?  If
that's the case, it surprises me.  There will be HLL access to this file.

I've used desc in SQL indices a number of times.

--
Jeff Crosby
UniPro FoodService/Dilgard
P.O. Box 13369
Ft. Wayne, IN 46868-3369
260-422-7531

The opinions expressed are my own and not necessarily the opinion of my
company.  Unless I say so.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.