why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

0 Answers  

---

Create a procedure to delete certain records from a table and display the total number of records deleted in this process. (Condition for deletion can be of ur choice, for instance delete all records where eid='')

2 Answers  

---

When can we use the where clause and the having clause?

0 Answers  

---

What are the query optimization techniques?

0 Answers  

---

hello..... i am an comp science engineering graduate planning to do ORACLE certification in PLSQL 9i. just wanted to know whats the possibility getting job is their openings???? is it worth doin that course n certification

1 Answers  

---

what are local and global variables and their differences? : Sql dba

0 Answers  

---

How do I run a sql query?

0 Answers  

---

Are subqueries faster than joins?

0 Answers  

---

take one table is t1 and in that column name is f1 f1 column values are 200 5000 3000 7000 300 600 100 400 800 400 i want display the values asc and desc in a single output. sample output is f1.a 100 200 300 400 500 600 etc...... and f1.d is 5000 4000 3000 2000 1000 etc...

9 Answers   Zensar,

---

How do I truncate a word?

0 Answers  

---

Which sql most popular?

0 Answers  

---

using cursors salesman get bonus as 10% of their salary , managers get 20% , analalist get 30%. generae a report showing the employee name, salary , bonus.

4 Answers   Fidelity,

---