Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

within

Status
Not open for further replies.
SMAlvarez

SMAlvarez

Programmer
Dec 4, 2005
27
US
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);
 
Sort by date Sort by votes
I'd use this:
order by TAGNUM,PACKID

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Upvote 0 Downvote
PHV is correct.
Sort the output by package ID within tag number
Click to expand...

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.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

iluvwitter
  • Locked
  • Question
Pull where date is within next 7 days
Replies
1
Views
159
PHV
PHV
iluvwitter
  • Locked
  • Question
IF Exists within Case statements 1
Replies
1
Views
134
PHV
PHV
OmenChild
  • Locked
  • Question
Changing NULL values within SQL query
Replies
5
Views
239
JarlH
JarlH
James2020
  • Locked
  • Question
Counting duplicates within combinations of groups
Replies
2
Views
132
James2020
James2020
Astrocloud
  • Locked
  • Question
Commit within Update
Replies
6
Views
172
PHV
PHV

Part and Inventory Search

Sponsor

Back
Top