Try to search your question here, if you can't find : Ask Any Question Now ?

how to Apply AND operation in SQL

HomeCategory: stackoverflowhow to Apply AND operation in SQL
pragati asked 1 week ago

My Query is like Select * From T Where ID=1 AND ID=2 AND ID=3 And So On

These ID From Another Result Set Like Select ID From T2

If I Apply IN Operation SELECT * From T Where ID IN(1,2,3) It show if there is any entry for 1 or 2 or 3 But in my requirement their should be ID 1 AND 2 AND 3
means ID IS 1,2,3 if 2 is not there result should be empty
how to apply this query !! 1,2,3 is from another result set can’t use directly means can’t use where ID=1 AND ID=2 AND So On

1 Answers
Best Answer
Mannu answered 1 week ago
Your Answer

18 + 1 =

Popular Tags

WP Facebook Auto Publish Powered By :