Can we change the order in a select query with a specified collation sequence

Q

Can we change the order in a select query with a specified collation sequence?

✍: Guest

A

Yes we can specify a collate sequence in the order by clause. That will change the sort according to the collation defined in the order by claused.

ORDER BY
{
order_by_expression
[ COLLATE collation_name ]
[ ASC | DESC ]
} [ ,...n ] ]

2007-11-02, 4514👍, 0💬