/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 vote119 views1 answer
Oracle list user locked
SQL
8 votes93 views2 answers
Phpmyadmin password
SQL
1 vote119 views1 answer
Ora-01109 database not open in oracle 19c
SQL
0 vote88 views1 answer
Postgresql conectar
SQL
11 votes102 views3 answers
How to get last row of table in sql
SQL
0 vote111 views1 answer
Postgres - Login and connect as default user
SQL
0 vote116 views1 answer
How to combine first and last nae into one columb sql
SQL
0 vote101 views2 answers
Pop sql insert value into
SQL
10 votes112 views3 answers
How to fetch first 5 characters in sql
SQL
1 vote119 views2 answers
Copy table in sql
SQL