QotD Questions Archive – Page 393 of 551

Blogs

My life has some crazy travel stretches for sure. Between speaking, office visits, customer...

In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...

I’m excited to announce the release of a new open-source project that fully automates...

Comments posted to this topic are about the item Server-Level Table sizes

Comments posted to this topic are about the item ORDER BY alias

Comments posted to this topic are about the item Optional Parameter Plan Optimization in...

There is a table tmp_tab:

CREATE TABLE tmp_tab (
id int,
val int
);

INSERT INTO tmp_tab VALUES
(1, 1),
(2, NULL),
(3, 3),
(4, 4),
(5, 5);

You want to order the rows ids by the following expression:

    ISNULL(val, id) + 1

Which of the following queries produces the expected ordering and why? (Select all correct)