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