my version:
note how i provided ready to paste-and-test code for the table and sample data?
if you can do the same in the future, you will get much better, tested answers.
With YourTable ([Server],[AppID])
AS
(
SELECT 'AAABBB','1000' UNION ALL
SELECT 'AAABBB','1005' UNION ALL
SELECT 'ASFQRE','1001' UNION ALL
SELECT 'AGSFSD','1002' UNION ALL
SELECT 'CCCDDD','1003' UNION ALL
SELECT 'CCCDDD','1009'
)
SELECT T1.*
FROM YourTable T1
INNER JOIN (
SELECT
[Server]
FROM YourTable
GROUP BY [Server]
HAVING COUNT(*) > 1
) T2
ON T1.[Server] = T2.[Server]
ORDER BY
T1.[Server],
T1.[AppID]
Lowell