Select records that have column value larger than zero (0) in SQL Server

Question

donrsquot get records from a table on behalf of any id if there are multiple rows which have amount more than 0 rupees but there is a row in which row is containing 0 amount then i donrsquot want to show that recordsuppose i purchased in a week several times so my amount will be more than 0 for each day but if i did not purchased any day in that week then i donrsquot want to show my transactions in that weekID amountA     0A     60A     50A     80B     100B     50i want to show only B no

dharmendr · Accepted Answer

Hi  iammannCheck the below test querySQLDECLARE Test AS TABLEID VARCHAR10amount INTINSERT INTO Test VALUES 39A390INSERT INTO Test VALUES 39A3960INSERT INTO Test VALUES 39A3950INSERT INTO Test VALUES 39A3980INSERT INTO Test VALUES 39B39100INSERT INTO Test VALUES 39B3950SELECT  FROM TestSELECT  FROM TestWHERE ID NOT IN SELECT ID FROM Test WHERE amount  0Screenshot

Select records that have column value larger than zero (0) in SQL Server

Company

Explore

Follow us

Contact Us