Optional for Group By statement
Hell0,

I want optional query for group by.

In table records are :

1   pravin  123 2011-08-05 20:01:47

2   chandu  126 2011-08-05 21:01:47

3   chandu  128 2011-08-05 22:01:47

3   pravin  130 2011-08-05 22:01:47

I want following output :

3   pravin  130 2011-08-05 22:01:47
1   pravin  123 2011-08-05 20:01:47
3   chandu  128 2011-08-05 22:01:47
2   chandu  126 2011-08-05 21:01:47

(output require date in desc order )

Please let me know.
Optional for Group By statement
===

Hell0,

I want optional query for group by.

In table records are :

1   pravin  123 2011-08-05 20:01:47

2   chandu  126 2011-08-05 21:01:47

3   chandu  128 2011-08-05 22:01:47

3   pravin  130 2011-08-05 22:01:47

I want following output :

3   pravin  130 2011-08-05 22:01:47
1   pravin  123 2011-08-05 20:01:47
3   chandu  128 2011-08-05 22:01:47
2   chandu  126 2011-08-05 21:01:47

(output require date in desc order )

Please let me know.