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

Can some one please help with a query which will take only
max value of a column in a join.

Question Posted / debasish

Answer Posted / debasish

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

Is This Answer Correct ?

6 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the difference between having clause and where clause in sql server?

1039

How to backup encryption key ?

172

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

1022

What are the properties of the transactions?

1064

What is a schema in ms sql server 2005?

922

What kind of problems occurs if we do not implement proper locking strategy?

1368

Define Business Edition in SQL Azure?

100

How do database indexes work?

964

How can you check the level of fragmentation on a table?

994

What is difference between stored procedure and user defined function?

1041

What are dml triggers and types of dml triggers?

926

What stored procedure can you use to display the current processes?

841

How to create percentile function?

141

What happens if null values are involved in comparison operations?

920

Explain syntax for dropping triggers?

894