Using Subqueries To Join 2 More Tables Which Do Not Have Unique Primary and Foreign Keys
Using Subqueries to join 2 more tables which do not have distinct values in a column We want to find…
Rank a Place Visited By a Customer- Microsoft SQL Server – T-Transact
This is a short guide to getting ranking or rating from Microsoft Sql Server customers. Ranking is taken by checking…
Splitting Values in one Column to Multiple Columns using CASE Expression Statement SQL Server
Sometimes, you would want to split values in a column into separate rows in SQL server. This is a simple…
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…
MySQL – Summarizing Data – SUM COUNT -MIN -MAX – AVG – DOGNITION Database
Summarizing Data This week we are looking at five most common aggregate functions used to summarize information stored in tables:…
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….