SQL Command for the following table.
Posted
by Sanju
on Stack Overflow
See other posts from Stack Overflow
or by Sanju
Published on 2010-04-16T03:49:43Z
Indexed on
2010/04/16
3:53 UTC
Read the original article
Hit count: 281
I have a table named with "Sales" having the following columns:
Sales_ID|Product_Code|Zone|District|State|Distributor|Total_Sales
Now i want to generate a sales summary to view the total sales by zone and then by district and then by State by which distributor for the last/past month period.
How can i write a Sql Statement to do this? Can anyone help me Plz. Thanks in advance.
And i have another question that, how can i select the second largest or third largest values from any column of a table.
© Stack Overflow or respective owner