how do you know the version of your mysql server? : Sql dba

0 Answers  

---

What is bulk compiling in pl/sql.?

0 Answers   MCN Solutions,

---

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,

---

Is drop table faster than truncate?

0 Answers  

---

i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.

2 Answers   IBM, Loginworks, OFSS,

---

---

how does a local variable is defined using t-sql? : Transact sql

0 Answers  

---

How to call shell script from pl sql procedure?

0 Answers  

---

can we use out parameter in a function?Give an example.

4 Answers   Logica CMG, TCS,

---

Can there be 2 primary keys in a table?

0 Answers  

---

what is try_catch block in procedure

0 Answers  

---

ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.

1 Answers   Zensar,

---

Write the order of precedence for validation of a column in a table ?

2 Answers  

---