It seems like you're asking for a SQL command to create a view based on certain conditions. Here's how you can do it:

```sql
CREATE VIEW newyorkstaff AS
SELECT * FROM salesman
WHERE city = 'New York';
```

This command does the following:

1. `CREATE VIEW newyorkstaff AS`: This part of the command creates a new view named 'newyorkstaff'. A view in SQL is a virtual table based on the result-set of an SQL statement.

2. `SELECT * FROM salesman`: This part of the command selects all columns from the 'salesman' table.

3. `WHERE city = 'New York'`: This is the condition for the view. Only the rows where the city is 'New York' will be included in the view.

Question

It seems like you're asking for a SQL command to create a view based on certain conditions. Here's how you can do it:

```sql
CREATE VIEW newyorkstaff AS
SELECT * FROM salesman
WHERE city = 'New York';
```

This command does the following:

1. `CREATE VIEW newyorkstaff AS`: This part of the command creates a new view named 'newyorkstaff'. A view in SQL is a virtual table based on the result-set of an SQL statement.

2. `SELECT * FROM salesman`: This part of the command selects all columns from the 'salesman' table.

3. `WHERE city = 'New York'`: This is the condition for the view. Only the rows where the city is 'New York' will be included in the view.

Knowee AI · Accepted Answer

It seems like you're asking for a SQL command to create a view based on certain conditions. Here's how you can do it:

```sql
CREATE VIEW newyorkstaff AS
SELECT * FROM salesman
WHERE city = 'New York';
```

This command does the following:

1. `CREATE VIEW newyorkstaff AS`: This part of the command creates a new view named 'newyorkstaff'. A view in SQL is a virtual table based on the result-set of an SQL statement.

2. `SELECT * FROM salesman`: This part of the command selects all columns from the 'salesman' table.

3. `WHERE city = 'New York'`: This is the condition for the view. Only the rows where the city is 'New York' will be included in the view.

From the following table, create a view 'newyorkstaff' to display details of salesmen who are based in New York.Sample table: salesman

Question

From the following table, create a view 'newyorkstaff' to display details of salesmen who are based in New York.

Solution

Similar Questions

Upgrade your grade with Knowee