dbTalk Databases Forums  

ORDER BY AND GROUP BY CLAUSE

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss ORDER BY AND GROUP BY CLAUSE in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #11  
Old   
--CELKO--
 
Posts: n/a

Default Re: ORDER BY AND GROUP BY CLAUSE - 11-28-2007 , 01:26 PM






Quote:
I did not develop that nonsense syntax it is supported in visual FoxPro and returns the correct results in a single select statement.
FoxPro came from the xBase family and not from any RDBMS, much less
SQL. Later, they tried to copy the keywords from SQL to make it look
more familiar when xBase lost out. MDX does the same kind of thing,
but with truly horrible irregular syntax.

The results are not correct in the SQL model, as a I verbosely
explained in my last posting.

Quote:
VFP was developed by Dave Fulton the acquired by Microsoft so I assumed they developed it ... Moveover it works!
Hey, I like Dr. Dave! I was at the ComDex when FoxPro was unveiled
with ACCESS by Bill Gates. Dr. Dave presented FoxPro; Gates did
ACCESS.

Foxpro ran great and Dr. Dave was super smooth as a presenter -- It
was like Mr. Wizard teaches DB and explains Rushmore technology. His
nice relaxed voice and flawless demo were the kind of thing I want to
be able to do on stage.

ACCESS was not ready for prime time -- or even Beta. It sorted dates
alphabetically, had no UNION (the GUI people could not think of a good
graphic so the DB people were told to kill it), then crashed and blue-
screened.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.