/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 vote235 views1 answer
Normalization in database 2nd normal form
SQL
0 vote244 views1 answer
Materialized view redshift
SQL
6 votes225 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
1 vote227 views3 answers
Connection string mysql
SQL
0 vote216 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
9 votes231 views2 answers
Sql limit to 5 results
SQL
0 vote238 views1 answer
Create table as select sql server error
SQL
0 vote303 views1 answer
How to check common records in 2 table
SQL
0 vote220 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
0 vote220 views1 answer
Concat column value of same user in mysql
SQL