MySQL Forums
Forum List  »  MySQL Query Browser

Sql Query Needed
Posted by: Bala murugan
Date: September 08, 2015 03:22AM

I need A sql query, I stuck This is a duff one please help For that following,
cardNo userName tablename hours date
1 a a 12 12-06-2015
1 a a 5 11-06-2015
2 b b 3 15-06-2015
1 a a 8 12-06-2015
2 b b 3 21-06-2015
1 a a 12 14-06-2015
2 b b 10 8-06-2015

cardNo is a unique one. i need to display all details and total hours for each card no like us
cardNo userName tablename total hours
1 a a 37
2 b b 16
Please tell the mysql query.. Immediately

Options: ReplyQuote


Subject
Written By
Posted
Sql Query Needed
September 08, 2015 03:22AM
September 25, 2015 12:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.