SQL Query to find records between minimum and maximum range values

anoopsin...

SOLVED CLOSED ACTIVE ANSWERED
User: anoopsingh
Posted: on May 04, 2015 02:27 AM
Forum: SQL Server
Answer: 1
Views: 2758

I want to fillter data base on minimum price and maximum and I have 2 columns minPrice and maxPrice how can I pass maxPrice value to get the data between price?

select * from tblPrice
declare @minPrice int

set @minPrice=500
select * from tblPrice where @minPrice BETWEEN minPrice and maxPrice

Shashika...

0 1

Reply
ANSWER
User: Shashikant
Replied: on May 04, 2015 02:50 AM
Modified: on May 04, 2015 02:54 AM
Report

Here I have created sql script that full-fill you condition.

SQL

CREATE TABLE #temp(Id INT,MinPrice INT,MaxPrice INT)

INSERT INTO #temp VALUES(1,1000,3000)
INSERT INTO #temp VALUES(2,2000,5000)
INSERT INTO #temp VALUES(3,3000,5000)
INSERT INTO #temp VALUES(4,3000,6000)
INSERT INTO #temp VALUES(5,5000,8000)

DECLARE @maxPrice INT,@minPrice INT

SET @minPrice = 3000
SET @maxPrice = 6000

SELECT * FROM #temp WHERE MinPrice >= @minPrice AND maxPrice <= @maxPrice

DROP TABLE #temp

Screenshot

I hope this will help you out.

SQL Query to find records between minimum and maximum range values

Company

Explore

Follow us

Contact Us