Can we give 2 or more conditions by using where?

Answer 1

Yes you can!
SELECT * FROM users WHERE Id > 100 AND Name = 'James'

Answer 2

Yes
for example.

select *
from Nepal
where location = 'Katmandu' and salary > 10000 and last_name = 'Ghimire' ;

Answer 3

Absolutely! You just have to join your conditions using the AND keyword if you want them all to be true or the OR keyword if just one of them needs to be true.

Examples:
SELECT * FROM students
WHERE state='New York' AND age>16

this will give a list of all students older than 16 that are from New York

SELECT * FROM students
WHERE state='New York' OR age>16

This will give a list of all students either from New York or older than 16.

Answer 4

You can use AND , OR operators between the conditions according to your requirement.

SELECT * FROM TableName
WHERE CONDITION1 AND CONDITION2

SELECT * FROM TableName
WHERE CONDITION1 OR CONDITION2

Likewise you can join two or more conditions. You can use AND and OR at the same time.

SELECT * FROM TableName
WHERE (CONDITION1 or CONDITION2) and CONDITION3

Answer 5

Yes , you can use as many time as you want but you need to use boolean operators like AND , OR , NOT

Answer 6

yes,why not
SELECT * FROM TableName
WHERE ColumnName1=Value1 AND(also you can use OR) ColumnName2=Value2 AND(OR)...

Answer 7

yes.. using connectives AND or OR
syntax:
select column_names_list
from table_names
where condition1 AND (/OR) condition2

Answer 8

select ename from emp
where ename= 'SMITH' and ename='KING';

this is a proper example to use 2 conditions

Answer 9

yes

Answer 10

yes

Answer 11

select name,id from emp where id =101 or name=any other row name;

Answer 12

how can use joint table

Answer 13

no