How do you change a value in sql?

0 Answers  

---

have table with two columns with datatypes as number and varchar and the values in A column like 1,2,3 AND B column values like a,b,c. now need to display data in a single column as 1,a,2,b,3,c.

8 Answers   IBM, Zensar,

---

Explain foreign key in sql?

0 Answers  

---

Is a view faster than a stored procedure?

0 Answers  

---

What are the different schemas objects that can be created using pl/sql?

0 Answers  

---

Explain ddl statements in pl/sql?

0 Answers  

---

The select into statement is most often used to create backup copies of tables or for archiving records?

0 Answers  

---

Explain dml and ddl?

0 Answers  

---

what are the differences among rownum, rank and dense_rank? : Sql dba

0 Answers  

---

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

0 Answers  

---

How to display all Friday's in a year with date?

4 Answers   Flipkart,

---

Hi, Can anybody please explain me the flow of the below query. I am not able to understand how this query works. This query is for finding the Nth highest salary.. SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal); If N = 2 then second highest salary will be the o/p. If N = 3 then third highest salary will be the o/p. and so on.. Thanks, Nitin

5 Answers   Deloitte, Ness Technologies,

---