List the computers which have warranties expiring within a year. How do I put this in a SQL Query?
select computer_id,datediff(day,warranty_expiration,getdate())as daysleft
from computers;This would show computer id and the days left but I don't know how to find the exact answer.
You need to add a WHERE clause to your query.
Yes (14) | ![]() | |
No (14) | ![]() | |
I don't know (15) | ![]() |