A simple question about dates?

3107869

The table is as follows:
id
2017-1-1
2017-1-4
2017-1-9
...

Find the nearest 2 records of a record

For example: 2017-1-4

Previous 2017-1-1
Next 2017-1-9

If it is the last or first record, give a prompt respectively.

michealhenry

What is the "closest" criterion?

2017-1-1
2017-1-3
2017-1-4
2017-1-9

For such data, which two of 2017-1-4 should be the closest?

prajna

select top 1 * from t order by datediff (day, '2017-1-4', id)

我是杀人狂

select id = identity (int, 1,1), a. * into #a from tablename a
It is more convenient to check from the temporary table.

cv4bf5d65fd

Previous
select max (id) from tablename where id <'2017-1-4'
next
select min (id) from tablename where id> '2017-1-4'

cv4bf5d65fd

Previous
select distinct max (id) from tablename where id <'2017-1-4' order by id
next
select distinct min (id) from tablename where id> '2017-1-4' order by id

3107869

Should be less than / greater than

zalinzhang

cv4bf5d65fdis creative.