what is the difference between the query and corelated query

8 Answers   HSBC, IBM, TCS, Xenosoft,

---

What does joining a thread mean?

0 Answers  

---

how to convert dates to character strings? : Sql dba

0 Answers  

---

How to display Row Number with Records in Oracle SQL Plus?

0 Answers   MCN Solutions,

---

write a query to find out the no. of employees whose age is less than 25 and max of salary for the employees belonging to a particular department is less than 20000

6 Answers  

---

What are the popular database management systems in the it industry?

0 Answers  

---

How to convert lowercase letters to uppercase and uppercase letters to lowercase in a string. (ex, AbcdEfG should convert as aBCDeFg)

3 Answers   TCS,

---

Write a sql query to get the third highest salary of an employee from employee_table?

0 Answers  

---

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,

---

What is sqlerrm?

0 Answers  

---

What is compound trigger?

0 Answers  

---

What is the difference between left join and right join?

0 Answers  

---