Sorting in SQL Server by two columns

Question

I have an employee table with below details

EMPid   TimeIn.             TimeOut
---------------------------------------------
123     1 Jan 2016 10:10    NULL
123     NULL                1 Jan 2016 18:30
123     1 Jan 2016 9:10     NULL
123     NULL                1 Jan 2016 18:00

I need output with order by time in ascending order. Below is sample output.

EMPid     TimeIn.              TimeOut
------------------------------------------------
123       1 Jan 2016 9:10      NULL
123       1 Jan 2016 10:10     NULL 
123       NULL                 1 Jan 2016 18:00
123       NULL                 1 Jan 2016 18:30

So what you tried that does not work? This is very basic question. Just look for `ORDER BY` clause in SQL. — Amit Joshi, May 16 '17 at 05:02
It is just for sample. Time in or time out may be in any order. — Jayant Satkar, May 16 '17 at 07:24
Possible duplicate of [SQL Server ORDER BY date and nulls last](http://stackoverflow.com/questions/5886857/sql-server-order-by-date-and-nulls-last) — Amit Joshi, May 16 '17 at 07:42

score 2 · Answer 1 · answered May 16 '17 at 05:08

2

SELECT * FROM Employee ORDER BY TimeIn, TimeOut

answered May 16 '17 at 05:08

eigenharsha

2,051
1
23
32

SHD · Accepted Answer · 2017-05-16T06:34:06.507

-3

Try this,

DECLARE @employee TABLE (EMPid INT,TimeIn DATETIME,TimeOut DATETIME)

    INSERT INTO @employee(EMPid,TimeIn,TimeOut)
    VALUES(123,' 1 Jan 2016 10:10',    NULL),
    (123,NULL,  '1 Jan 2016 18:30'),
    (123,' 1 Jan 2016 9:10'  ,   NULL),
    (123, NULL     ,           '1 Jan 2016 18:00')


SELECT * FROM @employee ORDER BY ISNULL(TimeIn,TimeOut)

edited May 16 '17 at 06:34

answered May 16 '17 at 06:12

SHD

399
3
12

Sorting in SQL Server by two columns

2 Answers2