SQL elapsed times

Calculating elapsed time between time values can be an interesting problem that is easily solved even when data anomalies are present.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(21)

You rated this post out of 5. Change rating

2024-09-20 (first published: 2013-09-26)

18,914 reads

Blogs

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...

One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....

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...

Comments posted to this topic are about the item AI Experience Gap that we...

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)