Answer Posted / phani

we can use, but select columns and having columns should
use with aggregare functions

ex:
select max(empid), min(marks)
from employee
having max(empid_id)>100

Which language is supported by sql server?

561

---

List out the difference between union and union all in sql server?

525

---

How to make conditional sum in ssrs?

132

---

How to use values from other tables in update statements in ms sql server?

559

---

What are indexes in sql?

580

---

---

What are different type of Collation Sensitivity?

556

---

what is the different types of backups available in sql server? : Sql server database administration

504

---

How do I find sql server instance name?

512

---

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

615

---

What is normalization of database? What are its benefits?

519

---

What is temporal data type?

526

---

what is the difference between a primary key and a unique key? : Sql server database administration

531

---

You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

627

---

What new data source types were added in ssrs 2014?

107

---

What is a non equi join?

544

---