Answer Posted / anand

select empname,salary from tableA where(empname in (select
empname from tableA group by empname having count(empname)
>1))order by empname

What are the hotfixes and patches in sql server?

1017

---

What is resource db in sql server?

1023

---

Explain various data region available in ssrs with their use?

933

---

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

983

---

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

881

---

What are the encryption mechanisms in sql server?

1028

---

Why is the need for data conversion transformations?

1063

---

What do you understand by the denormalisation?

956

---

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1682

---

What is the difference between Triggers and Stored Procedure?

1095

---

what is a self join? : Sql server database administration

1036

---

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

985

---

is it important for a database administrator to understand the operating system and file access? : Sql server administration

1029

---

What is difference between order by and group by?

1004

---

How do I find the size of a sql server database?

928

---