WHAT IS USE OF COALESCE KEYWORD

step 1:

CREATE TABLE COLLEGE(SID NVARCHAR(10),SNAME NVARCHAR(20),PLACE NVARCHAR(20))

　

Step 2:

 

INSERT INTO COLLEGE VALUES(1,'SURESH',NULL),(NULL,'RAMESH','PUDUKKOTTAI'),(3,'RAMU','COIMBATORE')

-- ABOVE QUERY WILL RUN ONLY SQL 2008,2012

 

STEP 3:

 

SELECT COALESCE(SID,SNAME,PLACE) AS 'STUDNAME' FROM COLLEGE

 

STEP 4:

 

Post your Ans  http://jssql.blogspot.in/

 

 

 

What is output below query?

Question 1:

Employee table has 2 column eid,ename

CREATE TABLE EMP(EID NUMERIC(10),ENAME NVARCHAR(20))

INSERT INTO EMP VALUES(1,'devi')

INSERT INTO EMP VALUES(2,'TIRU')

INSERT INTO EMP VALUES(3,'Ram')

INSERT INTO EMP VALUES(4,'Saran')

What is output below query?

 

SELECT EID ENAME FROM EMP

 

 

OutPut:

 

???   Post your Answer http://jssql.blogspot.in/