Retrieve Selected rows from database

SELECT * From Schem.Table1 WHERE Name = 'Ramneek'

This query retrieves the Name details from the Table1 where the name is ramneek.

Ramneek Sharma