Training and tips to get certified with Microsoft (Part 2)
In my previous post I answer the first of the regular questions I usually get in regards of the MCSA certification,...
2017-08-08
251 reads
In my previous post I answer the first of the regular questions I usually get in regards of the MCSA certification,...
2017-08-08
251 reads
In my previous post I answer the first of the regular questions I usually get in regards of the MCSA certification, if you haven't seen it I encourage you to...
2017-08-08
2 reads
In the last weeks, while I was preparing for one of the certification exams, I got a lot of questions from collegues, asking questions such as How do you...
2017-08-02
7 reads
In the last weeks, while I was preparing for one of the certification exams, I got a lot of questions...
2017-08-02
141 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...
We're trying to understand how quick new versions of SQL server can be. Obviously...
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
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