sql - MYSQL: Select sum values from one column into multiple columns grouped by values selected from second table -

-

i have 2 tables

table 'earning':

id | amount | date       | currency_id ----------------------------- 0  | 100000 | 01-01-2015 | 0 1  | 200000 | 01-01-2015 | 1 2  | 300000 | 01-01-2015 | 0 3  | 400000 | 02-01-2015 | 1 4  | 500000 | 02-01-2015 | 1

table 'currencies':

id | code --------- 0  | usd 1  | eur

so have possibility add new currency @ time.

is possible select both tables following result?

date       | earned_usd | earned_eur ------------------------------------- 01-01-2015 | 400000     | 200000 02-01-2015 | 0          | 900000

thank lot!


Comments

Post a Comment

Popular posts from this blog

java - unable show chart in xls document using jasper reports -

-
Image
i new jasper reports . able export data through jasper reports excel sheet. when created pie chart in ireports , showing on preview. when write below code in jsp file view report in jasperviewer , shows data along chart. when try save document (that in jasperviewer, gives many ways of saving report either in pdf or rtf or xls) xls error came in console net.sf.jasperreports.engine.jrexception: cell cannot added. however when remove chart .jrxml file, able export data excel file. read jr chart inserted image in excel document. xls document not taking images. below jsp file: <%@ page language="java" contenttype="text/html; charset=iso-8859-1" pageencoding="iso-8859-1" import="java.sql.*,java.util.*, net.sf.jasperreports.engine.*,java.io.*, net.sf.jasperreports.engine.design.*, net.sf.jasperreports.view.jasperviewer" %> <!doctype html public "-//w3c//dtd html 4.01 transitional//en" "http://www.w3.org/tr/html...
Read more

java.lang.RuntimeException: Could not generate dummy secret at sun.security.ssl.RSAClientKeyExchange.<init> -

-
i working on java ee application (netbeans ide 8.0.2, glassfish 4.1, jdk 1.8.0_45). the access pages of application should secured https, modified web.xml : <security-constraint> <web-resource-collection> <url-pattern>/*</url-pattern> </web-resource-collection> <user-data-constraint> <description/> <transport-guarantee>confidential</transport-guarantee> </user-data-constraint> </security-constraint> when deploy & start glassfish via netbeans can access application via https://localhost:8181/myapp/ when bundle application in .war file , deploy manually copy of same glassfish installation files netbeans uses, exception while trying connect application: warning (35) grizzly0013: exception during filterchain execution java.lang.runtimeexception: not generate dummy secret @ sun.security.ssl.handshaker.checkthrown(handshaker.java:1429) @ sun.security.ssl.sslen...
Read more

javascript - How to change image src on success AJAX -

-
the form: <form action="/user/updateprofilepicture" id="uploadphotoform" method="post" enctype="multipart/form-data"> <button class="btn btn-onetraffic btn-responsive btn-large">+change photo</button> <input class="btn btn-onetraffic btn-responsive btn-large" style="opacity: 0; height: 34px; margin-top: -34px;" type="file" id="uploadphoto" name="file" accept="image/*"> </form> div want image source changed: <div id="img-container"> <img id="upslika" src="#"/> </div> i images url server through json i tried : success:function(){ console.log("success"); $("#upslika").attr("src", res.pictureurl); }, res response the success callback must this: success: function (res) { ...
Read more