Answer Posted / avanish kumar

if you have a table emp and you have to find fourth maximum
salary from emp table then you will have to write this
query.....

select top 1 sal from (select top 4 * from emp order by sal
desc) as sal order by sal

Is sql server is free?

1017

---

Is it safe to delete log files?

973

---

wat wil hapn if we give the both read and deny read permission to user?

2151

---

How to select some specific columns from a table in a query in ms sql server?

1047

---

How adventureworkslt tables are related?

984

---

How to perform backup for certificates in sql server? : sql server security

1145

---

Is it possible to create trigger on views?

1030

---

What happens if the update subquery returns no rows in ms sql server?

1177

---

What is data modeling and Reterminal integrity?

2011

---

How real and float literal values are rounded?

1200

---

can a database be shrunk to 0 bytes, if not, why? : Sql server administration

1312

---

Explain in brief how sql server enhances scalability of the database system?

1026

---

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

1073

---

How to retrieve error messages using odbc_errormsg()?

1107

---

What does man by sql wildcard characters in sql server?

1106

---