I want to skip sundays and i want two dates in amonth

Question

My requirement was i want to to take data for first two days of every month eg(01/08/2016-02/08/2016, I any of this day fall on sunday i want to check next day also that 03/08/2016

 

I need sql query for that

Please do need full o us

 

Answer 1

code  to insert data  into table .program ask user to enter item name , id , price ,quantity .


public static void save(EntityPurchase epr)

        {

            OleDbDataAdapter da=new OleDbDataAdapter("Insert into shop values ('"+epr.Itemid+"','"+epr.Iname+"','"+epr.Quantity+"','"+epr.Price+"','"+epr.Curdate+"')",con);

            ds=new DataSet();

            da.Fill(ds,"temp");

        

        }


i have no idea about using sum clause n group by clause can you just explain it here ? any related links will be helpful

Answer 2

Could you show your code for adding 10 Car and trucks. Have you tried using sum clause and group by statement.