Query to get discount price in SQL Server

Question

pname dis a          10 b           10 c           15Count 10 0r 15 Like greater than 10 or 15dis     count10   315   110 is 3 count because it exists and satisfy abc all item and 15  only 1

ShaileshY · Accepted Answer

Hi SajidHussa Please refer below QuerySELECT DISTINCT dis SELECT COUNTdis FROM Discount d1 WHERE d1dis gt ddis as Count from Discount dScreenshot disCount 103151

Query to get discount price in SQL Server

Company

Explore

Follow us

Contact Us

dis%	Count
10	3
15	1