127k views
1 vote
write a t-sql statement to display only those sales agents whose last name begins with an a from the sales agent table above.

1 Answer

4 votes

Answer:

Sure! To display only those sales agents whose last name begins with an "A" from the sales agent table, you can use the following T-SQL statement:

```sql

SELECT *

FROM sales_agent

WHERE last_name LIKE 'A%'

```

This query uses the `LIKE` operator with the pattern 'A%' to match any last names that start with the letter 'A'.

User Titlacauan
by
8.3k points

No related questions found