C#
- 8 ответов
- 0 вопросов
2
Вклад в тег
string ext=FileName.Substring(FileName.LastIndexOf('.'));string ext = System.IO.Path.GetExtension(FileName);string[] temp= FileName.Split('.');
string ext =temp[temp.Length-1];System.IO.FileInfo fi = new System.IO.FileInfo(FileName);
string ext = fi.Extension;System.Text.RegularExpressions.Regex extend = new System.Text.RegularExpressions.Regex(@"(?:.*\.)(.*)");
string ext = extend.Match(FileName).Groups[1].Value;SELECT a.*
FROM test a
INNER JOIN (
SELECT a.product_code, a.brand, minday, min(price) as minprice
FROM test a
INNER JOIN (
SELECT product_code, brand, MIN(day) minday
FROM test
GROUP BY product_code, brand
) b
ON a.product_code = b.product_code
AND a.brand = b.brand
AND a.day = b.minday
GROUP BY product_code, brand, day) b
ON b.product_code = a.product_code
AND b.brand = a.brand
AND minday = a.day
AND minprice = a.price
WHERE по желанию