Help Needed to write select statement
479546Jun 27 2007 — edited Jul 9 2007I have a table whose rows like this:
slno name testno
1 reni 1
2 arun 2
3 jithu 3
4 rajesh 4
5 shiju 1
6 Thomas 1
7 Thomas 2
8 Thomas 3
9 Thomas 4
many rows like above.I want to select names who have attended all the test that is testno 1,2,3,4
Looking forward to help from u