Answer Posted / sivasiva

create table emp

empid empname
----- --------
101 a
102 b
103 a
104 c
105 a
select empid from emp groupby empid,empname having count>1

What is model database? : SQL Server Architecture

1189

---

How many types of schemas are there?

1091

---

Can we use where clause in union?

1124

---

What is pivot and unpivot?

1065

---

What is the full form of dql?

1024

---

What do you mean by stored techniques? How would we use it?

1079

---

Explain how does the report manager work in ssrs?

999

---

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

1664

---

How to execute stored procedure in select statement sql server?

1112

---

What is view in sql?

951

---

Explain different types of locks in sql server.

1128

---

How many types of subqueries are there in sql server?

1033

---

Define cross join in sql server joins?

1078

---

What is order of B+tree?

1152

---

How to list all tables in the database using odbc_tables()?

1116

---