Skip to main content
B
balumohan
Inspiring
April 28, 2009
Question

Filter Resultset

  • April 28, 2009
  • 1 reply
  • 765 views
query
studentiddivisionidexamidclassid
151753518418984
251853518418984
351953518418984
451753618418984
551853618418984
651953618418984
751853418428962
851853518428962
951853618428962

Please consider the following resultset. I want a query which can get the divisionid

examid classid and student id in which all the students are present.

ie. I want the resultset as

query
studentiddivisionidexamidclassid
151753518418984
251853518418984
351953518418984
451753618418984
551853618418984
651953618418984

Please help me out!!!

This topic has been closed for replies.

1 reply

D
Dan_Bracuk
Inspiring
April 28, 2009

It looks like a simple query of queries using "where classid = 8984" as your filter.  Or, if all you need are the filtered results, add that to you original query.

Am I missing something?

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices