Answer Posted / justus

create table emp

empid empname
----- --------
101 a
102 b
103 a
104 c
105 a

select empname from emp group by empname having count(empname)>1

What are the different kinds of ssrs reports?

206

---

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

976

---

How many ways to create table-valued functions?

932

---

Define master database?

985

---

Explain different types of locks in sql server.

1008

---

What is a result set object returned by odbc_exec()?

950

---

How to check parameter value in stored procedure sql server?

910

---

How to manipulate data from one table to another table ?

907

---

What do you mean by data manipulation language?

946

---

What is an inner join?

912

---

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

1000

---

How to set a database state to offline in ms sql server?

965

---

What are the differences between left join and inner join in sql server?

1038

---

Explain tablesample?

944

---

Explain the categories of stored procedure?

885

---