|
|
| Author |
Message |
ashwini patil
New User
Joined: 15 Oct 2007
Posts: 2
Location: pune
|
|
|
|
hi all,
I want a query to select only the null values from my table? |
|
| Back to top |
|
 |
References
|
 Posted: Fri Oct 19, 2007 11:55 am Post subject: Re: Query to select only the null values from my table |
|
|
|
|
hemanth.nandas
Active User
Joined: 18 Aug 2007
Posts: 117
Location: Chennai
|
|
|
|
Hi Aswini,
| Quote: |
| I want a query to select only trhe null values from my table? |
| Code: |
SELECT * FROM your_table
WHERE your_field_where_null LIKE NULL |
|
|
| Back to top |
|
|
vasanthkumarhb
Active User
Joined: 06 Sep 2007
Posts: 298
Location: Bang,iflex
|
|
|
|
Hi,
| ashwini patil wrote: |
hi all,
I want a query to select only the null values from my table? |
SELECT * FROM TABLE_NAME WHERE VAR-NAME IS NULLS;
Regard's
Vasanth, |
|
| Back to top |
|
|
|
|
