Home How to get only rows <= (Quantity) Transact-SQL
 Hi I recently wanted to have a report where we can see only the rows that are less or equal than a quantity example I have this table USER QUANTITY JOHN 2 JOHN 3 JOHN 1 JOHN 3  and I want to show only the rows where the Total is 5 and it should show USER QUANTITY JOHN 2 JOHN 3  I never tried this kind of query and I dont know where to start Can you help me?