Re: ORDER BY AND GROUP BY CLAUSE
- From: bwalton_707@xxxxxxxxx
- Date: Tue, 27 Nov 2007 15:27:42 -0800 (PST)
On Nov 27, 5:34 pm, "Tony Rogerson" <tonyroger...@xxxxxxxxxx> wrote:
Both are very different products.
Try this...
SELECT id, max( date )
FROM anytable
GROUP BY id
ORDER BY id, date desc
The jibe about ansi standards and MS not following them is a bit cheap, in
SQL Server you can use the ansi standard if you want - well, a lot of the 92
implementation anyway.
I'm not familiar with vfp - does it follow the ansi standard - the syntax
you posted doesn't look familiar.
--
Tony Rogerson, SQL Server MVPhttp://sqlblogcasts.com/blogs/tonyrogerson
[Ramblings from the field from a SQL consultant]http://sqlserverfaq.com
[UK SQL User Community]
Hi Tony,
VFP supports multiple standards including their own sql standards.
There is an engine behavior flag that governs which variation FoxPro
Uses.
If you are interested here is a link to another forum about it...
http://fox.wikis.com/wc.dll?Wiki~Enginebehavior~VFP
The syntax I ended up using was a variant of this, with part of it
wrapped in a CTE for readability.
Just seemed like a lot of code for such a simple task ... Moveover my
last post was incorrect it should
not have said duplicate records.
SELECT I1.invoice_nbr, C.customer_name, C.shopping_addr, C.acct_nbr
FROM Invoices AS I1,
Customers AS C
WHERE I1.acct_nbr = C.acct_nbr
AND I1.posting_date
= (SELECT MAX(I2.posting_date)
FROM Invoices AS I2
WHERE I2.acct_nbr = C.acct_nbr);
I only been coding in sql server 2005 for about 6 month... I been
using foxbase then vfp forever however with it's end of life all new
projects are in sql
and there just seems to be ALOT more coding involved to accomplish the
same task, especially when doing anything on a row by row level ....
SQL also lacks a built in debugger going into .NET is a pain . . .
But what can you do :) ....
I will try your suggestion and thanks everyone for the help...
Bryan
.
- Follow-Ups:
- Re: ORDER BY AND GROUP BY CLAUSE
- From: bwalton_707
- Re: ORDER BY AND GROUP BY CLAUSE
- References:
- Re: ORDER BY AND GROUP BY CLAUSE
- From: Tony Rogerson
- Re: ORDER BY AND GROUP BY CLAUSE
- Prev by Date: Re: Importing data into SQL Server 2005 via ODBC
- Next by Date: Re: ORDER BY AND GROUP BY CLAUSE
- Previous by thread: Re: ORDER BY AND GROUP BY CLAUSE
- Next by thread: Re: ORDER BY AND GROUP BY CLAUSE
- Index(es):
Relevant Pages
|
