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);

Recommended Answers

All 2 Replies

could it be:

Select * from software
order by PACKID, TAGNUM;

???

Im confused what it means by "within"

Select * from software order by TAGNUM, PACKID
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.