SELECT TOP Statement we use to select top data from a table, and top clause specifies that how many rows are returned from specific table.
If we want to show first row from the table all we need to do is specify number one iniside sql top statment.
Sql select date statment we use to retrive date from table.
To compare two dates we use between operator.