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 will you optimize a stored procedure optimization?

0 Answers  

---

how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?

9 Answers   Deloitte, Lason,

---

Explain time data type in sal server 2008?

0 Answers  

---

CREATE a table from another table

2 Answers  

---

How you can change the database name in SQL SERVER?

0 Answers  

---

CREATE TABLE [dbo].[HPMS_CompetencyTypes](CompetencyType varchar(50) ) go create trigger hpms_create_Insert on HPMS_CompetencyTypes for insert as if Exists ( select * from [HPMS_CompetencyTypes] where CompetencyType=(select * from [HPMS_CompetencyTypes])) begin Rollback tran Raiserror ('duplicate value',12,6) go insert HPMS_CompetencyTypes (CompetencyType) values ('new') I'm new to trigger can any one tell me where is the issue. Please.

2 Answers  

---

What is the maximum number of index per table?

0 Answers  

---

what stored procedure would you use to view lock information? : Sql server administration

0 Answers  

---

What is INTVAL( )and where we use Plz any body help me

1 Answers  

---

How will u find the query which is running in some other machine

4 Answers   CarrizalSoft Technologies, IBM,

---

Why we should not use triggers?

0 Answers  

---

Explain the flow of creating a cube? : sql server analysis services, ssas

0 Answers  

---