Re: Reg where clause -
07-09-2003
, 08:29 AM
There is no in-built mechanisms for doing that. If the sort order of a
specific attribute in an entity is important in your business model, your
logical model should capture & represent that information in your schema. In
SQL, this amounts to perhaps adding another column in your table which can
represent the required sort order. Then you can use this column in the ORDER
BY clause of your SELECT statement to get the rows sorted in your resultset.
--
- Anith
( Please reply to newsgroups only ) |