Project 1999

Project 1999 (/forums/index.php)
-   Technical Discussion (/forums/forumdisplay.php?f=40)
-   -   Need help with an SQL question on my homework (/forums/showthread.php?t=51527)

Quizy 10-13-2011 03:06 PM

Need help with an SQL question on my homework
 
Anyone know the answer to this ? Thanks in advance.


3. You have a Table “TaxPayer” with the values below. Write a SQL query that finds all records where the id column is NULL. What would the output be?
-------------------------
Name | id
Alex | 111
Bertha| 231
Bill | NULL
Chris | NULL
Lauren| 634
-----------------------

nilbog 10-13-2011 03:10 PM

"all records" = whole row?

in mysql :

select * from taxpayer where id is null

bill null
chris null

Quizy 10-13-2011 03:22 PM

Quote:

Originally Posted by nilbog (Post 432605)
"all records" = whole row?

in mysql :

select * from taxpayer where id is null

bill null
chris null

thanks nilbog.. thats what i thought as well.. just learning all this right now.. i appreciate the help


All times are GMT -4. The time now is 12:43 PM.

Powered by vBulletin®
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.