Query to Skip rows if Column value is NULL in SQL Server

Last Reply 6 months ago By dharmendr

Posted 7 months ago

I have table name with tblItems and table structure shows below

itId itemName 
1 Apple
2 pencil
3 Mango
4 pencil
5 Banana
6
7 Peach
8 Stawbery

I wanted is terminate the statement and return the result if there is any blank cell.

this is my expected out put

3 Mango
4 pencil
5 Banana

 

This question does not have replies that have been liked.