SQL statement Question!!?

1 ⤊

SQL statement Question!!?

Suppose you have a table defined as PUBLISHERS(pubID, pubName, address, city, state). Write an SQL statement that
returns all the records for publishers in the state of California.

2006-12-03 12:10:45 · 3 answers · asked by CLJ 1 in Computers & Internet ➔ Programming & Design

3 answers

If you'd like to return all columns, your query should be:

SELECT * FROM publishers WHERE state = 'CA'

If you'd like to return state only, your query should be:

SELECT state FROM publishers WHERE state = 'CA'

2006-12-03 13:12:57 · answer #1 · answered by edward 1 · 0⤊ 0⤋

select * from publishers where state = 'CA'

2006-12-03 20:25:21 · answer #2 · answered by Anonymous · 1⤊ 0⤋

What Solly said

2006-12-03 21:11:17 · answer #3 · answered by Jeffrey F 6 · 0⤊ 0⤋