/SQL/How to user id to show in from date to upto date in mssql server

How to user id to show in from date to upto date in mssql server

-- [=====[ Option 1 ]=====]
SELECT	TOP 1 
        TransID, [Date] 
FROM    #RNT1 
ORDER BY [Date] DESC, 
         TransID DESC

-- [=====[ Option 2 ]=====]
SELECT TOP 1 
       TransID, [Date]
FROM   #RNT1
WHERE  [Date]= (SELECT Max([Date]) FROM #RNT1)
ORDER BY TransID DESC

Source: codeproject.com

Similar codes

0 vote302 views1 answer
How to open mysql in docker
SQL
0 vote325 views1 answer
How to insert multiple values in a single column in sql
SQL
0 vote297 views1 answer
Why mysql is used?
SQL
0 vote297 views1 answer
Compare if is null sql
SQL
1 vote283 views1 answer
Find logged in users mysql
SQL
1 vote331 views1 answer
Mysql count all table rows
SQL
8 votes310 views2 answers
Grant all privileges database postgres to user
SQL
0 vote287 views1 answer
Check index sql server
SQL
1 vote308 views1 answer
"i_am_a_dummy flag" in MySQL
SQL
0 vote303 views1 answer
Sql remove last 2 digit
SQL