Alternatives in selection of dataset rows?

Questions
1

As an example, suppose I have a table such as

exTabl.png
exTabl.png474×172 6.63 KB

that is in the form of a Mathematica Dataset. In Excel I can select rows with specifications such as column a >.6 and column d either g or h. I am able to figure out how to use Select to specify rows for which column a>.6 and column d equal to g, but I have not been able to find the syntax to specify the alternative of column d equal to g or h. Can anyone help me with the correct command?

Thanks.
[1]: https://community.wolfram.com//c/portal/getImageAttachment?filename=exTabl.png&userId=290459

2

Hi Mike,

Here is one way

SeedRandom[123];
dataset = 
 RandomReal[1, {4, 3}] // 
    MapThread[(Append, {#, {"e", "g", "h", "g"}}] & // 
    Map[AssociationThread[{"a", "b", "c", "d"} -> #] &, #] & // 
    Dataset

dataset[Select[#b > 0.3 && MemberQ[{"g", "h"}, #d] &]]
3

Thanks Rohit. That was the information I needed.