Answer Posted / udathayadav

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

What is an expensive query?

536

---

Does a sql server 2005 select statement require a from?

578

---

How to name query output columns in ms sql server?

536

---

List the advantages of using stored procedures?

558

---

Define outer join?

529

---

---

Can we take the full database backup in log shipping?

536

---

Tell me what is the stuff and how does it differ from the replace function?

537

---

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

551

---

What are the types of database recovery models?

597

---

What is difference between order by and group by?

573

---

what is the sql equivaent of the dataset relation object ?

1567

---

What does set rowcount do?

510

---

What are statistics?

566

---

explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

1976

---

what exactly sql injuction.how to overcome.....

2035

---