3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

1 Answers   Fintellix,

---

What is the difference between stored procedure and view?

0 Answers  

---

What is a sql instance vs database?

0 Answers  

---

What is normalization ?

9 Answers   BirlaSoft, CTS, HCL,

---

i need department wise top 2 employees salary.which logic i will use

17 Answers  

---

---

Which tcp/ip port does sql server run?

0 Answers  

---

What is not in sql?

0 Answers  

---

write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh

3 Answers   TCS,

---

Is nosql relational?

0 Answers  

---

What are crud methods?

0 Answers  

---

How to download oracle sql developer?

0 Answers  

---

what is 'mysqladmin' in mysql? : Sql dba

0 Answers  

---