我有一个产品表,上面有150万行。我想得到产品和过滤器(关于它的类别,品牌等)
我这样做:(场景是:我输入id为35的类别,我想获取它及其子产品)
SELECT distinct r_category as r_category,brand as brand,price as price,offer_id FROM Product where Product.status = 1 and Product.r_category IN (35,279,280,274,276,278,277,275,39,294,295,296,38,292,293,290,291,289,34,271,272,2
我有一个搜索查询,它返回一组记录,但是我们使用分页,所以我们只返回10、25或50个数据的页子集。基本上,存储过程就是这样的。
WITH search_results AS
(
SELECT model, brandname, msrp,
ROW_NUMBER() OVER (ORDER BY @sortExpression) as rowNumber
FROM models
WHERE ...criteria....
)
SELECT * FROM search_results
WHERE rowNumber BETWEEN ((@pageNumber-1)
没有n个字符串需要与另一个字符串进行映射。
Ex : Bacardi_old - > Facundo
Smirnoff_old -> Pyotr
Seagram_old -> Joseph
This keep on ..... may be around 1000
有些字符串需要与重复字符串映射。
Ex : Bacardi_new -> Facundo
Smirnoff_new -> Facundo
Seagram_new -> Facun