Statistics with TSQL and R: Chi Square Test
As I move on from descriptive and largely univariate (one variable based) analysis of data into more multivariate data – one...
2016-09-21 (first published: 2016-09-13)
4,277 reads
As I move on from descriptive and largely univariate (one variable based) analysis of data into more multivariate data – one...
2016-09-21 (first published: 2016-09-13)
4,277 reads
We’ve been doing SQLSaturdays for eight years at Louisville now. We’ve had a quite a wide range of budgets depending on...
2016-09-13
586 reads
In this post I will attempt to explore calculation of a very basic statistic based on linear relationship between two...
2016-09-08 (first published: 2016-09-05)
3,190 reads
Simple steps towards understanding what is an Odds Ratio, and how do we arrive at it using TSQL and R scripts.
2016-08-30
2,431 reads
Make sure you have a working version of SQL Server 2016.
USE [master]
GO
/****** Object: Database [WorldHealth] ******/
CREATE DATABASE [WorldHealth]
CONTAINMENT = NONE
ON PRIMARY
(...
2016-08-16
387 reads
This TSQL tuesday is hosted by my good friend Jason Brimhall – Jason has put forth a creative challenge – plan to...
2016-08-10
289 reads
In the previous post I looked into some very basic and common measures of descriptive statistics – mean, median and mode,...
2016-07-24
599 reads
Make sure you have a working install of SQL Server 2016. The size of the database is only 8 MB.
USE...
2016-07-15
277 reads
I started my re-discovery of statistics with an introduction here. This second post is about descriptive statistics – very basic, simple...
2016-07-14
1,093 reads
I was a student of statistics in school and college. I didn’t get to use much of anything I learned...
2016-07-10
663 reads
By Kevin3NF
Can we normalize a couple of things? 1 – Trade Schools. Back in the...
Data isn't just about numbers and spreadsheets. It holds stories, patterns, and the answers...
By Brian Kelley
When I look at a system and think about its security model, the first...
hi we run 2019 std. we saw this week that someone hid 3 important...
Comments posted to this topic are about the item The "ORDER BY" clause behavior
Comments posted to this topic are about the item Are IT Certifications Still Relevant?
Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:
create table t1 (id int primary key, city varchar(50)); insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);If we execute the following query, how will the records be sorted in both environments?
select city from t1 order by city;See possible answers