Answer Posted / asit

Can someone answer to this. on below query where i want to find same salary in employee table,

SELECT * FROM EMPLOYEE WHERE (SAL IN (SELECT sal FROM empLOYEE GROUP BY sal HAVING COUNT(sal) > 1))

i am getting correct output.

but if i change it to 'COUNT(SAL)>=1' then it prints all the lines from the table.

What is difference between primary key and foreign key?

836

---

Can a database be shrunk to 0 bytes, if not, why?

1041

---

What Are the Main Features of SQL Azure?

115

---

What is the difference between mysql and sql server?

943

---

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

988

---

What is @@error in sql?

1023

---

What is database white box testing?

1080

---

What is the template in sql?

920

---

What is the default value of an integer data type in sql server 2005?

912

---

What is the difference RDBMS and Graph Database?

1006

---

How do I find query history in sql server?

879

---

What is key attribute?

873

---

How to list all objects in a given schema?

987

---

What is the difference between createstatement and preparedstatement?

885

---

How to connect Azure federated root database and apply federation in entity framework?

107

---