QotD Questions Archive – Page 386 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...

Call Cs 08218200233 Gedung Aurum, Jl. Ampera Raya No.37, RT.8/RW.2, Cilandak Tim., Ps. Minggu,...

Call CS 08218200203 Mal & Apartemen Ambasador, Jl. Prof. DR. Satrio No.R.18 Lt Dasar,...

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

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)