-- Solution 1 -- Say There are products in a table name products -- with a column named proPrice. -- Now insert your data 10, 10, 11, 12, 12, 13, 14, 14 -- Now run the scripts -- Keep practicing. Take care mushfiqcs@yahoo.com select proPrice, count(proPrice) from products group by proPrice Having count(proPrice)<2 S M Mushfiqur Rahman
M
mushfiqcs
@mushfiqcs
Posts
-
SQL Query -
SQL Query-- Solution 1 -- Say There are products in a table name products -- with a column named proPrice. -- Now insert your data 10, 10, 11, 12, 12, 13, 14, 14 -- Now run the scripts -- Keep practicing. Take care mushfiqcs@yahoo.com select proPrice, count(proPrice) from products group by proPrice Having count(proPrice)<2 S M Mushfiqur Rahman