D
D
Dmitry Krapivin2017-08-07 11:54:14
Database
Dmitry Krapivin, 2017-08-07 11:54:14

Is there an analogue of the sql command "TOP" in 1s queries?

Is there an analogue of the sql command "TOP" in 1s queries?
for example, when you need to get a string with a date that is closest to a given date, but less than or equal to it.
SELECT TOP(1) *
FROM Table1
WHERE Date < @MyDate
ORDER BY Date

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
Dmitry Krapivin, 2017-08-07
@kiru

Prompted:
CHOOSE THE FIRST (1)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question