OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Urgent -Order by

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Urgent -Order by [message #375043]

Fri, 20 July 2001 07:16

Rdamle
Messages: 4
Registered: July 2001

Junior Member

I ahve product table which contains products in different catgories , each category has seq no for products.
How do I write the query so as to order products by product category and by seq no with in each product category?

Report message to a moderator

Re: Urgent -Order by [message #375044 is a reply to message #375043]

Fri, 20 July 2001 07:35

Thanh Ngo
Messages: 1
Registered: July 2001

Junior Member

Here you are:

...
order by product_category, product_no;

Report message to a moderator

Re: Urgent -Order by [message #375045 is a reply to message #375044]

Fri, 20 July 2001 07:39

Rdamle
Messages: 4
Registered: July 2001

Junior Member

Thanks Thanh. I didn't know it was so simple!
I am still a novice :-)!

Report message to a moderator

Previous Topic:	Re: SQL Statement with Null return -- URGENT!!!!
Next Topic:	GETTING DESCRIPTION OF ALL VIEWS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 10:47:34 CDT 2024