select with multiple where condition in sql server -

select with multiple where condition in sql server -

sno col1 col2 col3 col4 ----------------------------------- a1 55 12 35 8 a2 6 15 21 6 a3 55 15 22 7

i want select sno , col1, col2, col3, col4 col1, col2, col3, col4 between -10 , 100

how should utilize multiple conditions in where?

try this:

select sno, col1, col2, col3, col4 your_table col1 between -10 , 100 , col2 between -10 , 100 , col3 between -10 , 100 , col4 between -10 , 100

sql sql-server