Answer Posted / jayakumar

please try this....

this is very usefull to you

select colunm_name from (select distinct(column_name) from
table_name where column_name is NOT NULL order by desc)
where rownum=n;

What is a cache in ssrs?

122

---

Write SQL queries on Self Join and Inner Join.

805

---

How to create function with parameter in sql server?

772

---

Explain data warehousing in sql server?

775

---

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

863

---

How real and float literal values are rounded?

825

---

How can you list all the table constraints in a database?

697

---

How do I connect to sql server database?

687

---

How is foreign key related to primary key?

720

---

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

663

---

Can we do dml on views?

732

---

Explain few examples of stored procedure over triggers?

696

---

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

733

---

What is provisioning, billing and metering, and connection routing concepts in the service layer?

109

---

How many types of attribute relationships are there? : sql server analysis services, ssas

777

---