Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have Table Sales. Like
Date, Name, Sales
10/01/2017, Rahul, 1500
12/01/2017, manoj, 1200
13/01/2018, Krish, 1300
naresh, 1200
I want remove the naresh record from table
Load Date, Name, Sales From [YourTable] where Name <>'naresh';
or
Load Date, Name, Sales From [YourTable] where Date<>null();
Load Date, Name, Sales From [YourTable] where Name <>'naresh';
or
Load Date, Name, Sales From [YourTable] where Date<>null();
Hi, try this
Load
Date,
Name,
Sales
from loaction where date<>'';