sql server - Using dynamic subqueries as column header -


i have table columns foo, bar , baz, foo repeated once each entry in bar, possible entry in baz each bar. example:

|-----|-----|-----| | foo | bar | baz | |-----|-----|-----| |  1  |  1  |alpha| |  1  |  2  |beta | |  1  |  3  |gamma| |  2  |  1  |delta| |  2  |  2  |beta | |  2  |  3  |kappa| |  3  |  1  |     | |  3  |  2  |     | |  3  |  3  |iota | |-----|-----|-----| etc

this table, in practice, has millions of entries. i'm looking situations 2 different foo entries have matching bar+baz entries (for instance, find foo 1 , foo 2 above, since both have beta in bar 2), given range of foo, it's not looking @ entire table.

i'm not sure if possible , various permutations of subqueries haven't worked far, i've been trying make query lists foo, next columns baz bar = x , foo = [the foo current row]

so table above, if looking @ bar 2 , bar 3, be:

|-----|-----|-----| | foo |bar=2|bar=3| |-----|-----|-----| |  1  |beta |gamma| |  2  |beta |kappa| |  3  |     |iota | |-----|-----|-----|

i'm relatively inexperienced sql, may not aware of particular syntax , haven't been able google up. i've tried using

select foo, (baz bar=2) 'bar=2', (baz bar=3) 'bar=3' from....

to no result, wasn't entirely unexpected. i've considered putting full select queries column header, can't see way reference 'foo line' in them. chasing impossible idea here? alternative use external application run many smaller queries , store data way instead, that's plan if cannot done entirely within sql server.

i'm looking situations 2 different foo entries have matching bar+baz entries (for instance, find foo 1 , foo 2 above, since both have beta in bar 2)

that's quite simple. can accomplish self-joining.

select * table1 t1 inner join table1 t2 on t1.foo != t2.foo t1.bar = t2.bar  , t1.baz = t2.baz

see working live here.

the rest of question don't understand @ all. it's has nothing asked above. why looking @ bar = 2 , bar = 3. , why gamma, kappa , iota listed in result? please clarify...


Comments

Post a Comment

Popular posts from this blog

Change php variable from jquery value using ajax (same page) -

what i'm trying this: i've php global variable $currentid , simple jquery script check if there "id" (page) in hash of url , if yes wanted give value $currentid . i've been reading lot , notice shall use ajax i'm not managing it. my code is: <script type="text/javascript"> $(document).ready(function(){ if (parent.location.hash != '' ) { var thecurrentid = parent.location.hash.split('#')[1]; $.ajax({ url: 'my.php', //current page type: 'post', data: {theid: thecurrentid }, datatype: 'json', success: function () { } }); } // code here }); </script> could me please? thank in advance. php server side language, meaning once has sent data browser, php variables , data cannot changed... however, using ajax, can send request php page , change data in dom based on result. consider th...
Read more

Pull out data related to my apps from Android Play Store and iOS App Store -

i want pull out data related apps (ratings, reviews, etc) google play store , apple app store ? how can accomplish ? i have found open source apis google mentioned not reliable. also there paid apis (e.g. appfigures) available. has idea how able pull data these play stores ?? i looking direction on how can accomplish this. can suggest ? we (appfigures) have been working on developing infrastructure give ability reviews , bunch of other data points major app stores several years :] we make available via our api though may want check out.
Read more

How can I fetch data from a web server in an android application? -

i want retrieve data web server in android application, , don't know begin. should use web services? i recommend these tutorials: connect android php , mysql , json in android , php , mysqli i used these tutorials , managed trying working without difficulty. between them describe each step in how attempting @ each stage, android application, database , web server side , has information included can process , use received information the thing add connect android php , mysql tutorial makes use of mysql_ in php deprecated. better use mysqli why included third link. the basic outline of want this: 1) in android app make request server php script using class this: import java.io.bufferedreader; import java.io.ioexception; import java.io.inputstream; import java.io.inputstreamreader; import java.io.unsupportedencodingexception; import java.util.list; import org.apache.http.httpentity; import org.apache.http.httpresponse; import org.apache.http.namevaluepair...
Read more