within

[SMAlvarez]

I have the problem:

"List all details about software records. Sort the output by package ID within tag number."

I'm a little confused about what they mean "within tag number"

Is the following sql right or wrong, if wrong can you help me fix it? Thanks.


Select * from software
order by PACKID in(TAGNUM);

 

[PHV]

I'd use this:
order by TAGNUM,PACKID

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[genomon]

PHV is correct.

Sort the output by package ID within tag number

This is common terminology, meaning tag number is the major sort filed, followed by as many others as needed.

Ever notice how fast Windows runs? Me neither.