Retrieve Selected rows from database

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

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