A Gentle Introduction to

SQL

NEW.

These questions have been submitted by users.



Is there any way to order records in specific way?
for instance, a table 'testTable' with column name 'list' has the following 6 values in 6 rows "a,b,c,d,e,f" If I use: Select * from testTable ORDER BY list ASC This will return in this order "a,b,c,d,e,f" But how to I get the values to be order like the following? "b,d,f,e,a,c"
access variations:
None

access
db2
mysql
oracle
postgres
sqlserver