Answer / swamy

Distinct Clause:
---------------
Distinct Clause Will Eliminate the Duplicate data or Rows
when u r selecting from table .So it Produce the Data or
Rows with out Duplication.Generally Distinct Clause will
be Placed on the Column of the Table.

Group Clause:
-------------
Group Clause will group or pack the rows or data based on
the Column(S).

Answer / rkvenky

distinct suppress the duplicates of data in the select stmt.
where as group by combines the data which we willgive in
order.
2.group by used at the end of select stmt
distint used in select stmt to columns
3.
group by is function where distinct is keyword

How many categories of data types used by sql server?

0 Answers  

---

What is the usage of sign function?

0 Answers  

---

What is the difference between clustered and a non-clustered index?

0 Answers   NA,

---

I am learning Testing, so i want to learn SQL also because SQL is important for Testing. I want to know which is best Institute in Ameerpet or SR Nagar or any other place in Hyd? Please help me.

7 Answers  

---

Do you know what is a with(nolock)?

0 Answers  

---

If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?

3 Answers  

---

How to invoke a trigger on demand?

0 Answers  

---

How to find the second highest salary of an employee?

0 Answers  

---

syntax and example for bitmap index in sql???

1 Answers  

---

Explain an automatic checkpoint

0 Answers  

---

What are synonyms?

0 Answers  

---

Can a synonym name of a table be used instead of a table name in a select statement?

0 Answers  

---