within
within
(OP)
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);
"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);
RE: within
order by TAGNUM,PACKID
Hope This Helps, PH.
FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?
RE: within
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.