Interview Questions Answers.ORG
Interviewer And Interviewee Guide
Interviews
Quizzes
Home
Quizzes
Interviews Databases Programming Interviews:BtrieveClipperData ModelingData StructuresDatabase AdministrationDatabase Administrator (DBA)Database AnalystDatabase DeveloperDB DevelopmentEDI/Data Integration ExpertFirebirdHierarchicalIBM DB2InformixJava DatabaseMariaDBMicrosoft Access DeveloperMongoDBMS SQL ServerMySQL ProgrammingNetworkNoSQLObject RelationalPostgrePostgreSQLProgressRDBMSRelationalSQLSQL AdministratorSQL and PL/SQLSQL Notification ServicesSQL server 2008SSRSStored ProcedureSybaseTeradata
Copyright © 2018. All Rights Reserved
Sybase Interview Question:
What is a Coalesce? What is the equivalent of Oracle/Db2 Coalesce Function in Sybase?
Submitted by: AdministratorCoalesce is also available in Sybase
This functions evaluates the listed expressions and returns the first non-null value. If all the expressions are null, coalesce returns null
USAGE: coalesce(expression, expression [, expression]...)
EXAMPLE: coalesce(initialqty,finalqty,middleqty)
Returns the first occurrence of a non-NULL value in either the initialqty or finalqty or middleqty
Submitted by: Administrator
This functions evaluates the listed expressions and returns the first non-null value. If all the expressions are null, coalesce returns null
USAGE: coalesce(expression, expression [, expression]...)
EXAMPLE: coalesce(initialqty,finalqty,middleqty)
Returns the first occurrence of a non-NULL value in either the initialqty or finalqty or middleqty
Submitted by: Administrator
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.