Answer Posted / lince thomas

select salary from(
select row_number() over(order by salary desc) as rno,*
from Employee)T where T.rno=6

What are the difficulties faced in cube development? : sql server analysis services, ssas

1021

---

Is truncate a dml command?

920

---

What happens to a trigger with multiple affected rows?

921

---

How to override dml statements with triggers?

1157

---

What is user defined stored procedures?

916

---

How to recover from sql injection? : sql server security

997

---

What is the difference between drop table and truncate table?

915

---

Explain microsoft sql server functions?

1089

---

What are key, name and value columns of an attribute? : sql server analysis services, ssas

992

---

What is a covered index?

927

---

Explain transaction server implicit?

972

---

What is a linked server in sql server?

1056

---

When does a workload on SQL Azure get throttled?

129

---

Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

1732

---

How to modify existing triggers using "alter trigger"?

991

---