Answer Posted / amit bhardwaj

SELECT COUNT(colmnName) FROM Tablename GROUP BY Columnname

You want to use a perspective in an mdx query. How do you select the perspective?

157

---

How do I find the query plan in sql server?

555

---

What are constraints in microsoft sql server?

572

---

Explain user defined views?

587

---

How can I get data from a database on another server?

520

---

---

Name the different type of indexes in sql?

543

---

What is attribute? : sql server analysis services, ssas

595

---

Please explain go command in sql server?

607

---

What is the purpose of object explorer and its features? : sql server management studio

607

---

what is package and it uses and how can u call a package

1569

---

What do you understand by the data quality services in sql server?

509

---

What are the advantages of using stored procedures?

546

---

How do I find the default sql server instance?

534

---

What is right outer join in sql server joins?

700

---

What are types of scd? : sql server analysis services, ssas

546

---