[thelist] MS SQL Syntax Help

Joshua Olson joshua at waetech.com
Tue Apr 16 12:23:01 CDT 2002


----- Original Message -----
From: "Means, Eric D" <eric.d.means at boeing.com>
Sent: Tuesday, April 16, 2002 1:15 PM
Subject: RE: [thelist] MS SQL Syntax Help


> SELECT TOP 10 *
> FROM my_table
> ORDER BY col_name_1 DESC

That is a solution to the TOP 10 problem, but is not the question I asked.
:)

> Does anyone know a trick to use SELECT's in the FROM clause
> in MS SQL 2k?






More information about the thelist mailing list