Answer Posted / vidyalakshmi.s

select * from emp1 where salary in (select salary from emp1
group by salary having count(salary) >1)

What is a derived table?

521

---

How to write a query with a full outer join in ms sql server?

568

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

548

---

What does this statement do @@rowcount?

558

---

Can group functions be used in the order by clause in ms sql server?

599

---

---

Explain relational data?

555

---

Explain different types of lock modes in sql server 2000?

530

---

Explain data warehousing in sql server?

604

---

How can you list all the columns in a database?

540

---

What are the different authentication modes in sql server? How can it be changed?

575

---

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

549

---

What will be query used to get the list of triggers in a database?

555

---

How to filter records of table in SQL SERVER?

605

---

Why is sql server log file full?

543

---

Explain the properties of the relational tables?

559

---