Select is a statement which is responsible to select table or database. This select statement have some conditional key word perform with the select statement if we need. Now given bellow the select statement code given bellow:
use [crud] go /*without condition*/ Select * from [dbo].[Teacher] /*with condition*/ Select * from [dbo].[Teacher] where Email='Love@gmail.com'
In this code we use * for select all value and second condition where clause for use condition.