Answer to Question #261326 in Databases | SQL | Oracle | MS Access for neethu

Question

Make a mailing list of vendors who provide bikes. Include a Type column that says Vendor. Make sure each distinct vendor only appears once. (5 rows)

Answer 1

SELECT DISTINCT vendor_name, product_selling, `type` FROM vendors WHERE product_selling='bike' LIMIT 5