Answer / apoorva garg

select a,b,
CASE WHEN (a>b) THEN a
ELSE b
END output
from a

Answer / satish tadepalli

select greatest(nvl(cola,0),nvl(colb,0)) from tablename

Answer / phani kumar

select greatest(cola,colb) from tblname;

Answer / suresh ramsng

select A,B,greatest(A,B) output from <tablename>

Can you have multiple SPs with the same name on a database?

6 Answers   CGI,

---

what is “go” in t-sql? : Transact sql

0 Answers  

---

How do I count rows in sql query?

0 Answers  

---

Does truncate table reset auto increment?

0 Answers  

---

how can we write a column values horizontal by using sql stmt; ex: select name from table_name;(actual output) a b c d require output is a b c d

5 Answers   Honeywell, Interact,

---

---

What is a mutating table and a constraining table?

0 Answers  

---

Is sql a backend?

0 Answers  

---

Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.

3 Answers   JPMorgan Chase,

---

Can i use Commit inside the Trigger? Suppose i use commit what will be happy (it's complied /executed/work)

6 Answers  

---

What are keys in sql?

0 Answers  

---

Why does sql need a server?

0 Answers  

---

tell us something about heap tables. : Sql dba

0 Answers  

---