Difference between aggregate function and analytical function?

3 Answers   Metric Stream,

---

suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dpt table has a field dept id,dept name. Now I want to find out the emplyee list whose sal is between 2000-3000 from dept x.

7 Answers   Geometric Software, IBM,

---

How does a self join work?

0 Answers  

---

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

0 Answers  

---

what is the difference between clustered and non clustered index in sql? : Sql dba

0 Answers  

---

What view means?

0 Answers  

---

what is a database? : Sql dba

0 Answers  

---

what are the demerits of sql?

1 Answers  

---

What is the difference between view and stored procedure?

0 Answers  

---

What are different functions in sql?

0 Answers  

---

Name some usages of database trigger?

0 Answers  

---

Can you create a table with Primary Key not as the clustered index.

2 Answers   CGI,

---