Explain what is dbms?

0 Answers  

---

how to find the second highest salary from emp table?

211 Answers   CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar,

---

What is materialized view in sql?

0 Answers  

---

What view means?

0 Answers  

---

What are different types of functions in sql?

0 Answers  

---

Can we join more than 2 tables in sql?

0 Answers  

---

Is sql a scripting language?

0 Answers  

---

When is the update_statistics command used?

0 Answers  

---

what is the order of pre-defined exceptions.

6 Answers   TCS,

---

What is the difference between functions, procedures, and packages in pl/sql?

0 Answers  

---

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance

5 Answers   Target,

---

What is a CTE (Common Table Expression), and how is it different from a subquery?

3 Answers  

---