Re: [SQL] Search a range of cases/records

am Thu, dem 01.02.2007, um 12:56:28 -0800 mailte Wei ZOU folgendes: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Greetings: > > I have a dataset of two columns: > price amount > 99.5 1 > 99.7 8000 > 1003000 > 100.1 1000 > 100.5 500 > 100.8 1500 > 1052000 > 200100

[SQL] Search a range of cases/records

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Greetings: I have a dataset of two columns: price amount 99.5 1 99.7 8000 1003000 100.1 1000 100.5 500 100.8 1500 1052000 200100 etc I have to write a SQL query on how many price tags are within [price+-1] such as 98.5 to 100.5,