SQL server statement help?

Question

I need help Writing a sql statement here are the details

Write an SQL statement to display the WareHouseID and the sum of QuantityOnHand grouped by WareHouseID. Omit all SKU items that have 3 or more items on hand from the sum, and name the sum TotalItemsOnHandLT3. Show WarehouseId only for warehouses having fewer than 2 SKUs in their TotalItemsOnHandLT3 and display the results in descending order of TotalItemsOnHandLT3

Answer 1

supposing thath the table nmae is warehouse , query would be:



select warehouseid,sum(quantityonhand) as TotalItemsOnHandLT3

from warehouse

where quantityonhand<3

group by warehouseid having sum(quantityonhand)<2

order by 2 desc

Answer 2

Start with



select WareHouseID, sum(QuantityOnHand)

from table

group by WareHouseID



Then

http://www.sql-tutorial.ru/en/book_getting_summarizing_values.html

Answer 3

You have got to figure our what variety of information `decimalField` contains. Whether it is speculated to be an integer then you could use decimalField = 0 If it's a string, then you definately have got to quote it decimalField = 'zero' I recommend you take a appear at the constitution of your desk and see what variety of data you've gotten decimalField set to contain. To do what you are attempting to do, be sure it is set to `decimal` or `integer` and no longer `varchar` (which is most of the time the default surroundings) :)

Answer 4

Always give some indication of the database schema if you want query help. Otherwise, we'd just be guessing at what you want.

Answer 5

What's the database model?

Answer 6

you need to mention the database model

Answer 7

i am not understanding ur question ..yet first create table warehouse ( wID='char');



BEST REGARDS:

[e-mail]