Uncategorized Archives

INSTR Function in SQL

INSTR The instr() function allows you for searching through a string for set of characters.To show position of character of a string.It will return interger values Syntax: instr (string, search_str…

0 Comments

November 5, 2020

Uncategorized

How to merge two rows into one row in sql?

I have a demo table as EMPLOYEEID INDIPAY OTHERPAY ISACTIVE 1 200 300 true 1 100 150 false I want the output as follows EMPLOYEEID INDPAY_ISACTIVE INDPAY_ISNOTACTIVE OTHERPAY_ISACTIVE OTHERPAY_ISNOTACTIVE 1…

0 Comments

October 16, 2020

COALESCE Function SQL

November 16, 2020/

0 Comments
LEAST Function In SQL

November 7, 2020/

0 Comments
GREATEST Function in SQL

November 6, 2020/

0 Comments