|
View previous topic :: View next topic
|
| 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 |
|
 |
hemanth.nandas
Active User
Joined: 18 Aug 2007
Posts: 120
Location: India
|
|
|
|
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: 275
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 |
|
|
|
|
