I have a table similar to this 

```
   THid Sid TID Sealantid
    1   1   1   1
    2   1   2   1
    3   1   3   4
    4   1   4   1
    5   1   5   1
    6   1   6   1
    33  2   1   1
    34  2   2   1
    35  2   3   1
    36  2   4   1
    37  2   5   1
    38  2   6   1
    65  3   1   1
    66  3   2   1
    67  3   3   4
    68  3   4   1
    69  3   5   1
    70  3   6   1
    97  4   1   1
    98  4   2   1
    99  4   3   8
    100 4   4   1
    101 4   5   1
    102 4   6   1
    129 5   1   1
    130 5   2   1
    131 5   3   8
    132 5   4   1
    133 5   5   1
    134 5   6   1
    161 6   1   1
    162 6   2   1
    163 6   3   4
    164 6   4   1
    165 6   5   1
    166 6   6   1
    193 7   1   1
    194 7   2   1
    195 7   3   4
    196 7   4   1
    197 7   5   1
    198 7   6   1
    225 8   1   1
    226 8   2   1
    227 8   3   4
    228 8   4   1
    229 8   5   1
    230 8   6   1
    257 9   1   1
    258 9   2   1
    259 9   3   1
    260 9   4   1
    261 9   5   1
    262 9   6   1
    289 10  1   1
    290 10  2   1
    291 10  3   4
    292 10  4   1
    293 10  5   1
    294 10  6   1

```

Here I wanted to find records only Sid's "where all sealantid=1"

Simple query I tried this 

```
select * from table where sealantid=1

```

but this gives me all sid's but I want only SID's, Tid's (1 to 6) where all the sealantid=1

In this table 2 , 9