Our Training Programs

View all

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

All contents are copyright of their authors.

dont want records which has 0 amount in it in sql !

Home
Forums
SQL

dont want records which has 0 amount in it in sql !

Subin Thomas

7yAsked Mar 25, 2019, 12:00 AM958SQL

i have fetched records with 3 tables joined i got 42 row of it it has a column name amount which is year wise so it contains 0 amount as well as some amount eg 20045,43550 etc

so i want to add a case or something so that i can get only amount which is greater then 0

i think i will have to write a case for that in query but im not sure of it so need help on the same

thanks

subin.

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Subin Thomas7y ago
Piyush i cant share query im not supposed to but i have used similar case to my sql query as suggested by suraj
Piyush Pansuriya7y ago
Please share your query..
Suraj Kumar7y ago
You can try this query using Case.
Create table Test(Amount int)
insert into Test Values (0), (2000334), (343535), (0)

Select * from(
Select
    Amount, Case Amount when 0 then 0 else 1 end as Filter
from Test
)a where Filter = 1
Subin Thomas7y ago
hey piyush i couldnt use ">" symbol coz it will effect other records so i used a CASE and i got the needed records in my table
Subin Thomas7y ago
hey suraj

Amount
0
2000334
343535
0

so from above table i wanted value which is not zero

and i used a CASE and i got the required table
thanks for responding
Piyush Pansuriya7y ago
Hi Subin,
You can put condition in WHERE clause.
i.e.
SELECT AMOUNT FORM TABLE1
WHERE AMOUNT > 0
Suraj Kumar7y ago
Please put your sample data in table format I will try to help you.