Latest Blogs
Popular Posts
Recommended

Latest Blogs

ajax-loader

US Goverment’s Open Data

Data.gov

data.gov  is the home of the U.S. Government’s open data. Here you can find Federal, state and local data, tools, and resources of the U.S. Government. The Data.gov team works at the U.S. General Services Administration, and data on the site are provided by hundreds of organizations, including Federal agencies.

data.gov.uk/data

data.gov.uk

On the data.gov.uk  website you can find public data released by the UK  Government to help people understand how government works and how policies are made. Some of this data is already available, but data.gov.uk brings it together in one searchable website. There are datasets available from all central government departments and a number of other public… Read More

SUM

For this example I use the AdventureWorks2008DW database  and I’m processing the query inside MS SQL Management Studio 2008. The SUM function in T-SQL returns the sum of the numeric values in a given column. The basic statement is SUM(“column name”). Inside the select statement it will look as follows: SELECT SUM(SalesAmount) FROM FactInternetSales Above query will give you… Read More

T-SQL

T(ransact)-SQL is proprietary extension to SQL. SQL is an acronym for Structured Query Language.

How to SUM in excel

In excel you can sum cells automatically. For example you would like to get the sum of cell A1, A2, A3 and A4. You can select any specific cell to see the sum of these before mentioned cells and use the function =SUM(). Go to the cell where you would like to see the result… Read More

ajax-loader