Question

Consider the following Vendor table and write the queries.

Table Vendor

VENDORID VENDORNAME DATEOFREGISTRATION LOCATION

V001 Mother Dairy 20-02-2009 Delhi

V002 Havmor 01-04-2015 Gujrat

V003 Amul 12-05-2012 Kolkata

V004 Kwality walls 15-10-2013 Mumbai

(i) Write a Query to display the records whose location is Delhi.
​

Answer 1

Answer:

select from vendor where location is delhi;