Refining SQL query -


my query returning data. here query, sample data , sample of i'd like.

select sd.ident,sd.suniq, td.testc, td.testuniq, td.subtestc, ts.testscore, ud.metadept, max(ts.takendt)as testdate studemo sd, stutests ts, testdef td, udefstu ud ts.suniq =sd.suniq , td.testuniq = ts.testuniq , ts.suniq = ud.suniq , td.testuniq in ('2000089', '2000090', '2000091', '2000092') group sd.suniq, sd.ident, td.testc, td.subtestc, ts.testscore, ud.metadept, ts.takendt, td.testuniq order suniq

sample output 

ident   suniq   testc   testuniq    subtestc    testscore   metadept    testdate 102201  2001444 adept   2000091 l3  23  null    09/01/2006 00:00 102201  2001444 adept   2000092 l4  7   null    06/01/2007 00:00 101184  2001532 adept   2000092 l4  5   null    09/01/2006 00:00 101184  2001532 adept   2000092 l4  7   null    06/01/2006 00:00 101184  2001532 adept   2000092 l4  7   null    06/01/2007 00:00 590122  2001950 adept   2000091 l3  22  null    06/01/2007 00:00 590122  2001950 adept   2000090 l2  32  null    09/01/2006 00:00 141058  2004980 adept   2000089 l1  27  null    05/01/2006 00:00 141058  2004980 adept   2000090 l2  28  null    01/25/2008 00:00 141058  2004980 adept   2000090 l2  27  null    06/01/2007 00:00

wanted output 

102201  2001444 adept   2000092 l4  7   null    06/01/2007 00:00 101184  2001532 adept   2000092 l4  7   null    06/01/2007 00:00 590122  2001950 adept   2000091 l3  22  null    06/01/2007 00:00 141058  2004980 adept   2000090 l2  28  null    01/25/2008 00:00

try this. have many group by criteria, , need aggregates on remaining fields. desired output max values me:

select  sd.ident,         sd.suniq,          td.testc,          max(td.testuniq) testuniq,          max(td.subtestc) subtestc,          max(ts.testscore) testscore,          max(ud.metadept) metadept,          max(ts.takendt)as testdate studemo sd, stutests ts, testdef td, udefstu ud ts.suniq =sd.suniq , td.testuniq = ts.testuniq , ts.suniq = ud.suniq , td.testuniq in ('2000089', '2000090', '2000091', '2000092') group sd.suniq, sd.ident, td.testc, order suniq

Comments

Post a Comment

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

i trying find efficient way previous revision of file text comparison using sharpsvn. using (svnclient c = new svnclient()) { c.authentication.defaultcredentials = new networkcredential( configurationmanager.appsettings.get("svnserviceusername") , configurationmanager.appsettings.get("svnservicepassword") , configurationmanager.appsettings.get("svnservicedomain") ); c.authentication.sslservertrusthandlers += new eventhandler<svnsslservertrusteventargs>(authentication_sslservertrusthandlers); collection<svnfileversioneventargs> fileversioncollection = new collection<svnfileversioneventargs>(); svnrevisionrange range = new svnrevisionrange(0, this.hooks.revision); svnfileversionsargs args = new svnfileversionsargs(); args.retrieveproperties = true; args.range = range; foreach (svnchangeitem item in log.changedpaths) { string path = this.repositorypath + it...
Read more

c++ - Is it possible to compile a VST on linux? -

for class project i'm attempting write vst plugin backed cuda. current cuda workflow on linux box, i'd prefer compile , link there. according wikipedia , should possible (i couldn't find steinberg documentation relevant linux) can't find makefile or instructions on how build if aren't using xcode or visual studio. i'm vst 3 sdk doesn't support linux. when try compile plugin under linux, error: ./base/source/fatomic.cpp:39:30: fatal error: libkern/osatomic.h: no such file or directory this issue caused following code in "vst3 sdk/base/source/fatomic.cpp" #if mac #include <libkern/osatomic.h> #if mac_os_x_version_min_required > mac_os_x_version_10_4 #define native_atomic_type (volatile int32_t*) #else #define native_atomic_type (int32_t*) #endif #elif windows #include <windows.h> #endif but hope compiling under linux work vst sdk 2.4. reading. jvstwrapper seems run on lin...
Read more

url - Querystring manipulation of email Address in PHP -

i using third party application (email2http) send me emailid, body , message. unable retrieve email id due name appended on , enclosed < , >. here querystring getting. test.php?from=ajay+reddy &subject=cx&body=somebody when print variable in php returns name , not email id. $from = $_get['from']; echo $from; //output ajay reddy please suggest me how can emailid also. i dont want use post method due testing , debugging. it's working fine. forgot use htmlentities() in debugging.
Read more