0

What is the use of using null function.... In sql?

usage of null function

22nd Aug 2017, 2:22 PM
Selva Raj
Selva Raj - avatar
3 ответов
+ 4
select name, lastname, phone from addressbook where phone is null
22nd Aug 2017, 2:35 PM
Melih Melik Sonmez
Melih Melik Sonmez - avatar
+ 3
you can use it in your query to find empty records of you can make records default null to avoid of wrong info
22nd Aug 2017, 2:31 PM
Melih Melik Sonmez
Melih Melik Sonmez - avatar
+ 2
NULL is used to filter out missing values from the table. A scenario wherein you're supposed to get a report generated of the list of people whose last name is not null can be written as: SELECT fname, lname FROM people WHERE lname IS NOT NULL;
24th Aug 2017, 7:14 PM
Shubham Mishra
Shubham Mishra - avatar