Answer Posted / mohd javed

BY Tested in Postgres SQL : javedcc@gmail.com

select * from tablename as aliasname where (nth)= (select
count(sal) from tablename where aliasname.sal<=sal)

What is user-defined inline table-valued function?

954

---

Where are SQL server users names and passwords are stored in sql server?

1273

---

What is a transactions?

1041

---

What is the default fill factor value?

1080

---

If user is owning any SQL Objects, can we drop that user

2076

---

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

1032

---

According to you what goes into making the best database administrator? : sql server database administration

978

---

Can we write trigger for view?

1012

---

what is denormalization? : Sql server database administration

926

---

How can change procedure in sql server?

1066

---

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

183

---

Does index speed up select statements?

1012

---

Tell me what is the order in which the sql query is executed?

956

---

how we use window authentication connection with sql server.?

1152

---

What is for xml in sql server?

1076

---