What is null described testing for null in sql?, Database Management System

Assignment Help:

What is NULL? Give an example to described testing for NULL in SQL?

The NULL SQL keyword is used to represent either a missing value or a value which is not applicable in a relational table. Consider there is a relation:

Person(id, name, address, phone)
Now to search ids and names of person who do not have a phone is:
Select id, name
from Person
where phone is null

Related Discussions:- What is null described testing for null in sql?

Define- relational algebra, Define- relational algebra. The relational ...

Define- relational algebra. The relational algebra is a procedural query language. It having of a set of operations that take one or two relation as input and make a new relati

Define the schema at the intermediate level of abstraction, Define Accordin...

Define According to the levels of abstraction, the schema at the intermediate level is called Ans: As per to the levels of abstraction, the schema at the intermediate level is

What is persistency, What is persistency? Persistency ensures which dat...

What is persistency? Persistency ensures which data is stored and that after the object is no longer available (program stops running) the data will be available to other users

Stored and derived attributes, Attributes that are directly kept in the dat...

Attributes that are directly kept in the data base. For example, 'Birth date' attribute of a person. Derived Attributes that are not stored directly but can be derived

Data warehousing, job scheduling for different cubes

job scheduling for different cubes

Foreign keys , Foreign Keys and NULL Let us take the relation: ...

Foreign Keys and NULL Let us take the relation: DEPT DEPT ID DNAME BUDGET D1 M

Data model in DBMS, how many types of data model in DBMS? explain data abst...

how many types of data model in DBMS? explain data abstraction with its different level

Explain recursive relationship type, Explain Recursive relationship type? ...

Explain Recursive relationship type? Recursive relationship type: A recursive relationship is one in that the similar entity participates more than once in the relationship

What is the use of group by clause, What is the use of group by clause? ...

What is the use of group by clause? Group by clause is used to apply aggregate functions to a set of tuples. The attributes given in the group by clause are used to

Explain generalization and aggregation in e_r diagram, Explain the concept ...

Explain the concept of generalization and aggregation in E_R diagrams. Give one example for each one of them? Generalization: Consider extending the entity set account throug

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages