Difference between aggregate function and analytical function?

3 Answers   Metric Stream,

---

give the syntax of grant and revoke commands? : Sql dba

0 Answers  

---

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance Suneel Reddy

6 Answers   Target,

---

What is union and union all keyword in sql and what are their differences?

0 Answers  

---

Can ddl statements be used in pl/sql?

0 Answers  

---

Can you load data into multiple tables at once? : aql loader

0 Answers  

---

how to load data with out header and footer records in a database using sql*loader? pls tell me the answer urgently

1 Answers   Oracle, Wipro,

---

what is 'mysqld'? : Sql dba

0 Answers  

---

What is mutating trigger?How to avoid it??

3 Answers   Tech Mahindra,

---

Is join same as left join?

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,

---

Why we use triggers in mysql?

0 Answers  

---