Answer / ramesh

The Concept of joining a table with it self in called "self
join"

Answer / shekar

the concept of joining a table with it self in called "self
join"

Answer / rrrrrrrrrr

The Concept of joining a table with it self in called "self
join"

Answer / gagan

Self join correlated rows of a table with other rows in the
same table.

Eg:
select a.name+'issue the book= '+b.book form lib a,lib b
where rollno between 1 and 10

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

0 Answers  

---

Define self join?

0 Answers  

---

What is named query? : sql server analysis services, ssas

0 Answers  

---

What Is The Difference Between Primary Key & Super Key

3 Answers   Accenture,

---

Explain what is log shipping?

0 Answers  

---

---

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

0 Answers  

---

which backup strategy you are following at ur company

0 Answers  

---

What is the use of sql profiler in sql server 2012?

0 Answers  

---

Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.

1 Answers   Cognizant, HCL, Value Labs,

---

what is the difference between table and view

1 Answers  

---

explain different levels of normalization? : Sql server database administration

0 Answers  

---

MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE

2 Answers   IBM, TCS,

---