I am using this code:
Code: Select all
SELECT * FROM customer ORDER BY date DESCActually I wishes my result show as:1 Jacky 30.11.2009
2 Willy 02.12.2009
3 Jason 01.12.2009
1 Willy 02.12.2009
2 Jason 01.12.2009
3 Jacky 30.11.2009
Moderator: General Moderators
Code: Select all
SELECT * FROM customer ORDER BY date DESCActually I wishes my result show as:1 Jacky 30.11.2009
2 Willy 02.12.2009
3 Jason 01.12.2009
1 Willy 02.12.2009
2 Jason 01.12.2009
3 Jacky 30.11.2009