mysql - Selecting dates as columns for summary table -

-

इस उदाहरण तालिका और डेटा से: 

  टैब्लेट बिक्री (`sales_person_id` int, `बिक्री_डेट 'दिनांक समय,` बिक्री_माउंट` पूर्णांक); बिक्री में निवेश करें (`विक्रय_पंजी_आईडी`,` बिक्री_डेटा`, `बिक्री_अमित`) मूल्य (1, '2014-01-01 00:00:00', 10), (1, '2014-01-02 00:00:00 ', 12), (2,' 2014-01-03 00:00:00 ', 20), (1,' 2014-01-03 00:00:00 ', 15), (1,' 2014-01 -03 00:00:00 ', 3), (3,' 2014-01-05 00:00:00 ', 25);

जब उपयोग किया जाता है @startDate = '01/01/01' और @endDate = '2014/01/06 ' मैं इस प्रारूप में परिणाम वापस करना चाहता हूं: 

  आईडी | 20140101 | 20140102 | 20140103 | 20140104 | 20140105 | 20140106 | -------------------------------------------------- -------------------- 1 | 10 | 12 | 18 | 0 | 0 | 0 | 2 | 0 | 0 | 20 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 25 | 0 | -------------------------------------------------- --------------------

मुझे यकीन है कि यह एक ही क्वेरी में किया जा सकता है, लेकिन मेरे पास नहीं है इस समय कुछ भी करीब है अगर मैं कोई प्रगति करता हूं तो मैं संपादित करूंगा।


Comments

Post a Comment

Popular posts from this blog

Editing Python Class in Shell and SQLAlchemy -

-
I am working on the terminal on a shell script after this tutorial SQLAlchemy tutorial. I need to type gt; & Gt; & Gt; Sqlalchemy import column, integer, string & gt; & Gt; & Gt; Class user (base): __tablename__ = 'users' id = column (integer, primary_key = true) name = column (string) absolute name = column (string) password = column (string) def __repr __ (self): return "& lt ; User (name = '% s', absolute name = '% s', password = '% s') & gt; "% (Self.name, self.fullname, self.password) After the problem I have typed the password = column (string) I hit twice and changed .... >> I then took everything back but then an error was thrown because the class already exists ... I am not completely sure how to fix it. How do I open that slip in the shell script and edit it (Add DF to DRR) The error thrown below: / user / giripeters / TFSQLLX / Lib / python2.7 / site-packages / sqlalchemy / ext / decla...
Read more

rest - Basic cxfrs RESTful JAX-RS Service -

-
I am trying to get a basic CXF RS JX-RS example for working. Unfortunately, the GET on a resource which I want to return HTML does not apply the resource at all. Here is an extraction from spring bean: & Lt; Bean id = "HelloResource" class = "com.example.HelloResource" /> & Lt; Camelcontext xmlns = "http://camel.apache.org/schema/spring" & gt; & Lt; Route & gt; & Lt; From Yuri = "cxfrs: bean: rsssver" /> & Lt; From Yuri = "Log: Later? ShowAll = true" /> & Lt; / Route & gt; & Lt; / CamelContext & gt; Here is a quote from the related JAX-RS resource: @ path ("/") public class HelloResource {Private Final Log Log = LogFattery. GetLog (HelloResource.class); Public HelloResource () {log.info ("creating HelloResource ..."); } @GET @ path ("/ Hello") @ product ("text / html") public string hello () {log.info ("***** hello? ******...
Read more

ajax - Decimal('12000') is not JSON serializable -

-
I have a dijongo example running on Apache 2. One of my webpages is doing an AJAX callback to the project. Most of the time, it works great, but for some reasons I can not determine this, it stops working with Django from the following error: Decimal ('12000') is not a JSON serial Once I get this error once, it stops working for ever. I know that the only solution is to start Apache again. Python / Django is not changing, nor does the data requested by Ajax calls. I never got this problem when I ran my code on Django web server. @login_required def KPIInitTable (requested): kpi_values ​​= [ob. KPI.Obages '' As_json () for OB in March '' 'table_data': kPI_group, 'callheader': ['kpi', 'citecatcher', 'type', 'jan', 'february' 'April', 'May', 'Jun', 'Jul', 'Aug', 'September', 'Oct', 'Nov', 'Dec' '],' Roha Headers...
Read more