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 happens on checkpoint? : Sql server database administration

1021

---

How to skip remaining statements in a loop block using continue statements?

935

---

What is dirty page?

920

---

can a database be shrunk with users active? : Sql server administration

953

---

Is the log file is a part of file group?

976

---

Explain isolation levels that sql server supports?

988

---

What is transaction server consistency?

982

---

How to maintain a fill factor in existing indexes?

945

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

954

---

Explain datetimeoffset data type in sal server 2008?

852

---

Explain about the command-line tool SQLCMD?

1019

---

Why transaction is important?

934

---

What is the use of “join” in sql server?

1020

---

Describe in brief databases and sql server databases architecture.

944

---

What are the filtered indexes?

978

---