SELECT ... WHERE Category <> 'others'
UNION
SELECT ... WHERE Category='others'
> -Original Message-
> From: Tariq Murtaza [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 10, 2002 7:12 AM
> To: Fred van Engen
> Cc: [EMAIL PROTECTED]
> Subj
On Tue, Dec 10, 2002 at 04:12:22PM +0500, Tariq Murtaza wrote:
> Thanks for help.
> here is another solution for that...
>
> SELECT if (Category = 'others', '999', 0) as priority, ID, Category FROM
> TableName
> ORDER BY priority, Category
>
That's right. It has the same problem regarding o
Thanks for help.
here is another solution for that...
SELECT if (Category = 'others', '999', 0) as priority, ID, Category FROM
TableName
ORDER BY priority, Category
Tariq
Fred van Engen wrote:
On Tue, Dec 10, 2002 at 03:32:13PM +0500, Tariq Murtaza wrote:
I want to achieve recordset like
On Tue, Dec 10, 2002 at 03:32:13PM +0500, Tariq Murtaza wrote:
> I want to achieve recordset like below (sorting category by Name and
> including 'Others' at the end),
> I want to do that by single query ;), any idea???
>
>
> IDCategory
>
> 6 biochemistry
> 62