Search Tutorials

Latest Questions

Error in a code.
This is the question I posted yesterday: "I'm trying to write a program that has a text field for input, two buttons an
netbeans resource prob
Hi,please can you tell me how to include a file like an image in the jar package in netbeans so that i dont need to prov
Failed to run Online Quiz Application in JSP
Hi, I have been following your following link to run the online quiz application, but I failed to get the result scre
Pass by Reference
Hi Friends, What is Pass by value and Pass by Reference?can u please explain with examples.is java supports Pass by r
no driver
i am having problem connecting to DB2 database fro netbeans: program: import java.sql.*; import java.lang.*; i
min project with vb
i have do the min project with VB Frantend and oracle backend
Some additions for my previous question
This is the question I posted several hours ago: "I'm trying to write a program that has a text field for input, two bu
Writing a GUI program
Hello everyone! I'm trying to write a program that has a text field for input, two buttons and the output text area. A
How to display current date in textbox
Hi guys, I'm really need your help. This is my source code. <% if (status.equals("pending") && penanda==0)
Methods in Java
Hello. Currently i am involved in a group project and we have each been given a specific part of code to create our joi
All Questions...

Comments

MySQL Coalesce
In this section, you will learn about MySQL Coalesce. It selects the first non-null value of its arguments.

MySQL Coalesce

In this section, you will learn about MySQL Coalesce. It selects the first non-null value of its arguments.

Syntax:
coalesce(value,..): It returns the first non NULL value in the list. If there are no non-NULL values then it returns NULL.

Table: employee

CREATE TABLE `employee` (
`emp_id` int(11) NOT NULL auto_increment,
`emp_name` varchar(100) character set utf8 NOT NULL, `emp_salary` int(11) NOT NULL,
`emp_startDate` datetime NOT NULL,
`dep_name` varchar(50) NOT NULL, PRIMARY KEY (`emp_id`)
)

employee table data:

Table: empleavedetails

CREATE TABLE `empleavedetails` (
`id` int(11) NOT NULL auto_increment,
`emp_id` int(11) NOT NULL,
`no_of_leave` int(11) NOT NULL,
PRIMARY KEY (`id`)
)

empleavedetails table data:

Query:

select e.emp_name as Name, l.no_of_leave as NOL from employee e left outer join empleavedetails l on e.emp_id=l.emp_id;

Output: The output contains NULL values in the result list as shown below:

The null values are eliminated from the list using COALESCE. For example:

Query:

select e.emp_name as Name,COALESCE(l.no_of_leave,0) as NOL from employee e left outer join empleavedetails l on e.emp_id=l.emp_id;

Output:

� View all related tutorials

Related Tags: sql c performance query orm ui process form application io sed find using app for index call record records to

Leave your comment:
Name:
Email:
URL:
Title:
Comments:
Enter Code:
	Note: Emails will not be visible or used in any way, and are not required. Please keep comments relevant. Any content deemed inappropriate or offensive may be edited and/or deleted. No HTML code is allowed. Line breaks will be converted automatically. URLs will be auto-linked. Please use BBCode to format your text.