Get Numbers and Percentages from Tables – Microsoft Sql Server
Sometimes you want to get some numbers and also percentages for quick analysis. This is a quick simple way to get quick overviews
Want more information like this?
Similar Posts
Teradata Viewpoint – SQL Scratchpad – Writing Queries Dillard’s Department Store Database
Analysing ‘Big Data’ from a database with real world data requires retrieving data from the database by writing relevant queries. As part of “Managing Big Data with MySQL” by Duke University on Cousera, I dealt with real world data that comprise hundreds to millions of entries/rows. This is the database of Dillard’s Department stores, specifically, the UA_DILLARDS that contains…
Great Quick Transact-SQL Server Tutorials – Quick Revision and General Understanding
I receive a lot of emails about where to get quick and excellent resources for explaining most of the concepts of Transact-SQL (T SQL) and Microsoft SQL Server in general What is Transact-SQL or T SQL. T-SQL (Transact-SQL) is a set of programming extensions from Sybase and Microsoft that add several features to the Structured Query…
- Data Warehousing | Oracle | SQL | Teradata | Transact-SQL
Free Entity Relationship and Relational Schema Diagram Tool
ERDPLUS One tool I generally use when working on a projects, mini tasks and exploration is the ERDPLUS tool . It is quite simple and easy to use. It is a Free tool as well. Below are some diagrams I generated when i first got in contact with with tool. ERD DIAGRAMS: 1. 2. A…
