/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

8 votes262 views1 answer
Oracle all_source package body
SQL
1 vote267 views1 answer
Increasing font and zooming in mysql workbench
SQL
0 vote282 views1 answer
Tinydb add table
SQL
0 vote240 views1 answer
Suse start MySQL
SQL
0 vote270 views1 answer
Postgresql interview questions
SQL
0 vote255 views1 answer
Mysql add to value
SQL
0 vote267 views1 answer
How to drop a trigger in postgresql
SQL
-1 vote276 views1 answer
Get month and year from date in mysql sequelize
SQL
5 votes221 views1 answer
Copy table from one database to another mysql
SQL
0 vote276 views1 answer
Oracle change password expiration policy
SQL