Sql Group by
-
Dear all, Here i m facing a problem with some group by date here i m getting two rows of a single date for values fetching. if any one wants i can give the code for ur easy answer giving. thank you
sai krishna
-
Dear all, Here i m facing a problem with some group by date here i m getting two rows of a single date for values fetching. if any one wants i can give the code for ur easy answer giving. thank you
sai krishna
When you are using date as group by field then it create new group for each and every record with different time. ex/ 01/10/2007 10:10:00 PM 01/10/2007 12:10:00 PM so use Convert Function for Convert Date in dd/mm/yyyy fromat for correct answer
Best Regards, Chetan Patel
-
When you are using date as group by field then it create new group for each and every record with different time. ex/ 01/10/2007 10:10:00 PM 01/10/2007 12:10:00 PM so use Convert Function for Convert Date in dd/mm/yyyy fromat for correct answer
Best Regards, Chetan Patel
thanks i got it
sai krishna