What are aggregate functions in sql?

0 Answers  

---

What is the usage of when clause in trigger?

0 Answers  

---

State the difference between implict and explict cursor's?

7 Answers   CTS,

---

IF i write before / after insert / update trigger and i do rollback what will happen?

5 Answers   KPIT,

---

how will u find statistics of a database objects?

2 Answers   iFlex,

---

---

What is the meaning of disabling a trigger?

0 Answers  

---

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,

---

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

0 Answers  

---

source destination distance chennai bangalore 500 bangalore chennai 500 hyd delhi 1000 delhi hyd 1000 bangalore hyd 800 Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria. Based on the distance i want to display only one row using sql query?

4 Answers   JPMorgan Chase,

---

Explain what is a field in a database and record in a database?

0 Answers  

---

What is the life of an sql statement?

0 Answers  

---

how to concatenate two character strings? : Sql dba

0 Answers  

---