Answer / rajeevrohilla

In normal situation join are best since there is no
subquery for each record for the other table. but in some
situations Subquery are best. for example- when the
subquery results one or fewer (3 or 4 records) that it will
work faster since it also saves the joining time(if there
are more than 1 joining fields then joining takes lots of
time). Subquries also perform better when tables have less
amount of data.

Answer / parmanand

Joins are good, Sub queries are substantially faster than
cursor in most cases, however shower than other options that
might be available in SQL Server.

1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format

2 Answers  

---

why we use cursor?

4 Answers   CarrizalSoft Technologies, Melstar, TCS,

---

How to change server name in sql server?

0 Answers  

---

How can I know what query is executing by by a particural user? (using sp id or any othe way.)

2 Answers  

---

How to provide login information for a new odbc dsn?

0 Answers  

---

Does group by or order by come first?

0 Answers  

---

can we give the identity for existing column of the table? (already table contains 10(1-10) unique randam records)

2 Answers  

---

What is resource db in sql server?

0 Answers  

---

how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

0 Answers  

---

Explain what stored procedure sp_replcounters is used for? : sql server replication

0 Answers  

---

How to execute a sql statement using odbc_exec()?

0 Answers  

---

You are doing log shipping due to some reasons it is failing. How you will proceed from there

0 Answers  

---