Using the T-SQL select statement is quite simple to retrieve data from your database. This example returns data where the ID is 3.

USE databasename

SELECT ID, FirstName, LastName

FROM tablename

WHERE ID = 3;