While retrieving data based on primary key use select single whereas retrieving based on non-primary key use select up to.

Related questions