suppose I have following records
No(numeric) Name(varchar) Date_Time (timestamp)
1 Rajashri 1/1/2008 10:30:55
2 Rajiv 3/2/2008
05:07:09
I want output following way
No Name Date
1 Rajashri 1/1/2008
2 Rajiv 3/2/2008
Can write query for this.
please tell me aeap.
I need it urgently.
Thanks & Regards,
Rajashri Tupe