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

Write a SQL command to insert and update only a particular field?

0 Answers   ADITI,

---

what is the difference between table and view

1 Answers  

---

How to see the event list of an existing trigger using sys.trigger_events?

0 Answers  

---

What is the difference between char, varchar and nvarchar?

0 Answers  

---

What is normalization and denormalization in sql server?

0 Answers  

---

What are the different editions available in sql server 2000?

0 Answers  

---

What should we do to copy the tables, schema and views from one SQL Server to another?

3 Answers  

---

do views contain data ?

0 Answers   MCN Solutions,

---

Does transparent data encryption provide encryption when transmitting data across the network?

0 Answers  

---

Explain about Normalization?

0 Answers   Infosys,

---

There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"

2 Answers  

---

i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L

8 Answers  

---