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 difference between drop table and truncate table?

0 Answers  

---

what is checksum in sql server.........???

0 Answers   TCS,

---

how to insert the values in 5 table at a time Using any single statement ?

6 Answers   Infosys, Value Labs,

---

What is the syntax for encrypting a column in SQL Server?

0 Answers   MindCracker,

---

What is RMS migrations?

0 Answers   Satyam,

---

What are the different types of columns types constraints in the sql server?

0 Answers  

---

How do I start and stop sql server?

0 Answers  

---

why we use cursor?

4 Answers   CarrizalSoft Technologies, Melstar, TCS,

---

Which sql server table is used to hold the stored procedure script?

0 Answers  

---

Can multiple columns be used in sql group by clause in ms sql server?

0 Answers  

---

Relational calculus is what type of language?

0 Answers   HCL,

---

what is cluster and nin-cluster index?

4 Answers  

---