Answer Posted / madhur/amrutha

select ROW_NUMBER() OVER (ORDER BY names ASC) AS ROWID, *
into #temp from emp
select * from #temp where ROWID not in(
select b.ROWID from
(
select ROW_NUMBER() OVER (ORDER BY names ASC) AS ROWID, *
from emp
except
SELECT ROW_NUMBER() OVER (ORDER BY names ASC) AS ROWID, *
FROM
(
select names , sal from emp
union
select distinct names,sal from emp) as a ) as b)

drop table #temp

Are semicolons required at the end of sql statements in sql server 2005?

932

---

Explain Geometry datatype in sql server 2008 with example

918

---

What is difference between joins and subqueries?

1050

---

How to invoke a trigger on demand?

1026

---

When a primary key constraint is included in a table, what other constraints does this imply?

938

---

Can we write ddl in trigger?

864

---

What is the difference between varchar and nvarchar datatypes?

1033

---

Explain about nested stored procedure?

975

---

Where can you find the error log information? : sql server database administration

970

---

Which language is supported by sql server?

954

---

What is an active database?

961

---

What is the command used to recompile the stored procedure at run time?

1016

---

What are the advantages of stored procedure in sql server?

832

---

Should you normalize audio?

879

---

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

857

---