Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL Need query for rollup based on month and category
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


Shibin Varghese
Need query for rollup based on month and category
0 Answer(s)      2 years ago
Posted in : SQL


Hi,

Here is my question..

I have a table as below. trans_date,cateory,amount 1-1-11,1,10
2-1-11,2,20 3-2-11,3,15 23-2-11,4,12 13-5-11,4,19

Need a query to get result like

cateory,month1,month2,month5 1,10,00,00 2,20,00,00 3,00,15,00 4,00,12,19

please suggest a method..

Thanks for the help.. Shibin


Advertisement
View Answers

Related Tutorials/Questions & Answers:
Need query for rollup based on month and category
Need query for rollup based on month and category   Hi, Here is my question.. I have a table as below. trans_date,cateory,amount 1-1-11,1,10 2-1-11,2,20 3-2-11,3,15 23-2-11,4,12 13-5-11,4,19 Need a query to get result like
How to get sub category based on category from database using jsp and javascript.
How to get sub category based on category from database using jsp and javascript.  How to get sub category based on category from database using jsp and javascript
Advertisements
need query
need query  hi sir , i am beginner to sql.i need a query so that it can be helpful to my project. i have four tables each containing different fruits with different amounts. i need a query in such a way that when i say some
Need to get the Data based on Date
Need to get the Data based on Date  Hie , I am having a criteria where i need to get the data based on date . I have written the query as "from... that time field and execute the query can any one please help as soon as possible
Need a query to run in db2
Need a query to run in db2  hi all, I need a query to run in DB2...; Table 2- ACCOUNTS Fields-LEDGERCODE,ACCOUNTNUMBER,BALANCE FROM THE ABOVE I NEED A QUERY TO RETRIEVE ONLY THE ACCOUNTYPE=AFFILIATE FOR ACCOUNTNUMBERS FROM TABLE
Java Query(based on swing concept)
Java Query(based on swing concept)  I want a particular submit button to get disabled whenever i write some account number starting with 774 and 775 in a text box of that screen
need search query - WebSevices
need search query  I have a field in database as DOB. But I want... month = 10; int year = 1984; Connection con = null...); if (dob.compareTo(new Date(year - 1900, month - 1, date)) == 0
Role based login ..Need the concepts.. - JavaMail
Role based login ..Need the concepts..  Role based login how can i do that.. Constraint: i should have only one jsp page for all the user or usergroup... but depending upon the role the functions should change
How to execute mysql query based on checkboxes values in java swing application.
How to execute mysql query based on checkboxes values in java swing... have to execute query based on selection of checkboxes.Means I have to to execute query acording to the checkbox. whichever checkbox is selected query should
How to execute mysql query based on checkboxes values in java swing application.
How to execute mysql query based on checkboxes values in java swing... have to execute query based on selection of checkboxes.Means I have to to execute query acording to the checkbox. whichever checkbox is selected query should
How to execute mysql query based on checkboxes values in java swing application.
How to execute mysql query based on checkboxes values in java swing... have to execute query based on selection of checkboxes.Means I have to to execute query acording to the checkbox. whichever checkbox is selected query should
Need to implement Paging and field based sorting in JSP Servlet - JSP-Servlet
Need to implement Paging and field based sorting in JSP Servlet  Hi, Can some one please guide me how we can implement the paging and field based... Roll No. Class etc etc As per my requirement i need to first
Need help to create Struts 2 MySQL based HRMS application.
Need help to create Struts 2 MySQL based HRMS application.   Hi Sir, I am doing my project based on Human Resource Management system using struts 2 framework. I am beginner for struts framework. I tried to follow many example
Mysql Date Month
'. In this Example, The Query month (now( )) returns you value of the current month. month(now( ) ) : The month (now( ) ) return you the value of current month. Query... Mysql Date Month      
Mysql Date Query
Mysql Date Query       Mysql Date Query Date Query is used to return the current date, month and year... 'Mysql Date Query'. To understand this example we use current_date query
to renew leave to next month
to renew leave to next month  i need to make a project where an employee must be able to apply leave only once in a month, and if he doesn't use that leave in that particular month, it must be renewed to the next month so that he
Mysql Date Previous Month
a month (now( )) that return you current month value. Query for finding current month...) Query for finding Previous month:- Once you are able to find the current month, you can easily find the previous month before the current month. The Query month
Mysql Date Get Month
Mysql Date Get Month       The tutorial explains you the way to retrieve the current month... Month'. To understand this example, we use Month(Current_timestamp) 
need
need  i need a jsp coding based project plz help me
Mysql last day of month
Mysql last day of month       Mysql Last Day of Month is useful to provide you the last day of Month. Understand with Example The Tutorial illustrate
Calculate Month Difference in mysql - SQL
of date increasing or decreasing based on month like 31 and 30 .coding..._No, (month(sysdate())-month(Entry_Date)) from monthlytransaction ; so that based...Calculate Month Difference in mysql  hi , i am rahul.Can anybody
urgent need for jsp code with mysql query for uploading and downloading file - JSP-Servlet
urgent need for jsp code with mysql query for uploading and downloading file  can anyone tell me how to upload and download a doc file using jsp with mysql as the back end... and kindly help me to create the table too
Mysql date month name
the current value for the month of the year ,we use the following Query:  date_format(now ( ),%M') return you the current month of the year.  Query... Mysql date month name      
query
JFrame { //3 month table details JTable table=null; JScrollPane js=null
Query
(leftLayout); l8 = new JLabel(" Month of Birth "); c2=new JComboBox(s2
Mysql last day of month
( )) : The Query return the last day of the current month a s fieldname Last Day of Month.         Query... Mysql last day of month   
Selection based on other selection in jsp
. I want to populate the field on product_name based on the category name... based on the category would come in the product drop-down list. How can I do...Selection based on other selection in jsp  I am trying to create
sql query
numbers of sids.i want to delete the sid based on the mid.for that i need sql query plz help to me
sql query
numbers of sids.i want to delete the sid based on the mid.for that i need sql query plz help to me
sql query
numbers of sids.i want to delete the sid based on the mid.for that i need sql query plz help to me
How to Addding One Month with PHP ?
How to Addding One Month with PHP ?  Hi, I am very new in this php programming language. Can anybody will guide me how to add 1 month on a specific date on PHP. Please give any example or reference links. Please feel free
Advertisements
 

 

 

DMCA.com