In SQL, you can use the following command: select customerID,zip,soldBy from DallasData where active_status ==1 LIMIT 5;