/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

1 vote171 views3 answers
How to filter repeated same result using sql query
SQL
1 vote227 views1 answer
Sql server locks
SQL
0 vote172 views1 answer
Get records in sql according to month name and count
SQL
3 votes210 views3 answers
Docker create postgresql database
SQL
9 votes192 views5 answers
Sql limit
SQL
0 vote195 views1 answer
Mysqli last row
SQL
0 vote221 views1 answer
Grouping by email domain mysql
SQL
3 votes192 views1 answer
Oracle get trigger ddl
SQL
2 votes218 views1 answer
How to delete all duplicate items in mysql
SQL
14 votes193 views4 answers
Online sql compiler
SQL