How to perform this MySql Query

Posted by Jayakumars under Sql Server on 10/4/2015 | Points: 10 | Views : 332 | Status : [Member] [MVP] | Replies : 1
Hi
How to perform MySql Query following output need Mysql Query only By using Datewise.
as well as row wise.


Sno ShareNo Name Date Receptamt Payamt Total
1 1500 John 2015-09-10 1000 0 1000
2 1500 John 2015-09-18 0 500 500
3 1500 John 2015-10-04 500 0 1000
4 1500 John 2015-10-04 1000 0 2000
5 1500 John 2015-10-20 0 100 1900
6 1500 John 2015-10-21 0 500 1400

Mark as Answer if its helpful to you


Responses

Posted by: Rajnilari2015 on: 10/4/2015 [Member] [Microsoft_MVP] [MVP] Platinum | Points: 25

Up
0
Down
@JayaKumar, could you please provide the sample DML(CREATE) and DDL(INSERT) statements?Please provide that in your questions body by updating it.
Also please format your sample output for better readability.
Thanks in advance

--
Thanks & Regards,
RNA Team

Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response