Question

Is it possible to extract information based on more than one condition in a single query? How?

Answer 1

Answer:

Yes

Explanation:

If you are talking about conditional statements then you can use multiple contions within single if condition combine them using && (AND) logical operator.

If( a > 50 && a < 100)

{

     printf("A is greater than 50 and less than 100");

}