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 are the restrictions that views have to follow?

1031

---

List the different index configurations possible for a table?

984

---

What are the five characteristics of good data?

974

---

how can you attach more than 20 ldf files in sql server

2052

---

When I delete any data from a table, does the sql server reduce the size of that table?

1064

---

List the ways in which dynamic sql can be executed?

1062

---

What is factless fact table? : sql server analysis services, ssas

1098

---

Explain magic tables in sql server?

1107

---

How to delete a login name in ms sql server?

1128

---

How to connect to SQL Azure Database by using sqlcmd?

140

---

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1127

---

What is the difference between NOROW and LOCKROW?

2900

---

How to disable stored procedure sql server?

1671

---

 Explain what is sql override for a source taLle in a mapping?

1061

---

What stored by the model? : sql server database administration

1004

---