what is the syntax used for partition in tsql? : Transact sql

0 Answers  

---

How do I filter in sql profiler?

0 Answers  

---

How does postgresql compare to mysql?

0 Answers  

---

What is the Subquery?

4 Answers  

---

How do you update a sql procedure?

0 Answers  

---

---

What is the difference between the Primary and Foreign key?

7 Answers   Cap Gemini,

---

What's the difference between inner join and left join?

0 Answers  

---

I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for each deptno?

8 Answers   L&T,

---

Is not null in sql?

0 Answers  

---

What are different clauses used in sql?

0 Answers  

---

What is cascade in sql?

0 Answers  

---

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

1 Answers  

---