In a Distributed Database System Can we execute two queries simultaneously ? Justify ?

3 Answers  

---

how to get second highest salary in SQL(as/4000

29 Answers   iGate,

---

Which one of the following pairs of aggregate functions do you use with character fields? 1. COUNT(field) and MAX(field) 2. AVG(field) and COUNT(field) 3. MIN(field) and SUM(field) 4. AVG(field) and MAX(field) 5. COUNT(field) and SUM(field)

6 Answers   HCL,

---

how to create a primary key with out creating an index?

9 Answers   TCS,

---

I need a exceptoin in pl/sql block so that if any errors occur in the block then no exception should errors should raise?

1 Answers  

---

what is the Default Libraries for Oracle Report 6i

0 Answers   IBM,

---

How do sql triggers work?

0 Answers  

---

What is prepared statement in sql?

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 is HASH join?

2 Answers   Genpact, HCL,

---

Why stored procedure is better than query?

0 Answers  

---

Explain character-manipulation functions?

0 Answers  

---