Re: TOP 1

On 16-Jun-2015 08:21 -0600, Hoteltravelfundotcom wrote:

betwixt, other posts snipped

On 16-Jun-2015 07:35 -0600, Hoteltravelfundotcom wrote:

I have one table with all orders info and other table has the
shipping info. I only need to 'chain' one row from the shipping
table to get the ship via method. But its multi rows
so I trued top1 its not compiling. how to read just the first row
in sql on the i. I tried
top1, topn nothing is compiling.
(
SELECT TOP 1
STDTA.pshipll1.phviac

FROM
STDTA.pshipll1
WHERE
"SHPWEIGHT"."IDORD#" = STDTA.pshipll1.phord#
)

<<SNIPped>>

FETCH FIRST 1 ROW ONLY is the way.

But not without an ORDER BY, unless either all phviac values are
identical across the one phord# value or perhaps which non-distinct phviac
value is immaterial. If not the latter, then that order-by must be more
than on just order# or other than on just the order#; otherwise, which row
[and thus which value for phviac] is selected, would be unpredictable.

I don't use group by because am using

a logical that is order by order#

And the key of the LF matters, how? Querying a logical does not ensure
any order for how the rows are selected, despite the LF may be keyed; thus
why the ORDER BY is required in the subquery as mentioned above. So while
a GROUP BY query may be precluded for a valid reason, what is the key of
the LF is not a valid reason.

--
Regards, Chuck


--
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.