Answer / debasish

select max(alias.colomnname) from table alias
join table alis on
<condition>

Answer / vaibhavi_dixit

select max(alias1.columnname) from table1 alias1
join table2 alias2
on condition

What is the meaning of resultset type_scroll_insensitive?

0 Answers  

---

Are connections to sql server encrypted?

0 Answers  

---

What are sub-queries? Give example? In which case sub-queries are not feasible?

4 Answers   Infosys,

---

Why we use trigger in sql server with example?

0 Answers  

---

How to drop an existing schema in ms sql server?

0 Answers  

---

What is the fastest way to permanently delete a 1 million row table named customers?

0 Answers  

---

List some major differences between triggers and stored procedures?

0 Answers  

---

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

0 Answers   Aptroid,

---

What is a join and their types?

2 Answers   Challenger Financial,

---

What do you mean by subquery?

0 Answers  

---

What is Query Execution Plan? How does it help optimize or tune a database driven application?

2 Answers   Accenture, Polaris,

---

Tell me what is log shipping?

0 Answers  

---