>Sir I have these codes
>
>

>SELECT conn.session_id,
>DB_NAME(database_id) as [DB],
>host_name,
>connect_time,
> net_transport
>	   FROM sys.dm_exec_sessions AS sess
>JOIN sys.dm_exec_connections AS conn
>   ON sess.session_id = conn.session_id
>   where DB_NAME(database_id)='at20'
>and net_transport='TCP'
>

>
>It shows data like shown in attachment 1
>
>https://imge.to/i/GBYtf
>
>But I need only this data shown in attachment 2
>
>https://ibb.co/M8trjpr
>
>I mean every unique host_name with min(connect_time)
>
>Please help

SELECT 
  min(conn.session_id) as session_id,
  DB_NAME(database_id) as [DB],
  [host_name],
  min(connect_time) as connect_time,
  net_transport
FROM sys.dm_exec_sessions AS sess
   JOIN sys.dm_exec_connections AS conn ON sess.session_id = conn.session_id
where DB_NAME(database_id)='at20' and net_transport='TCP'
group by [sess].[host_name], db_name(database_id), net_transport;