5 lines
173 B
MySQL
5 lines
173 B
MySQL
|
/*1. Write a query to create a view for those salesmen belongs to the city New York.*/
|
||
|
|
CREATE VIEW newyorkstaff
|
||
|
|
AS SELECT *
|
||
|
|
FROM salesman
|
||
|
|
WHERE city = 'New York';
|