hi
how to query multiple fields in sql server.
i have table like this
Kode |
field1 |
field2 |
1 |
10 |
13 |
2 |
13 |
15 |
3 |
15 |
17 |
4 |
17 |
19 |
5 |
19 |
20 |
6 |
20 |
30 |
declare @value0 as float = 19
select * from table where field1 > @value0 and field2 <= @value0
i need display row 4, how to implement query in sql server
thanks