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 data compression?

941

Please explain go command in sql server?

991

What is logshipping and its purpose?

944

What is the recursive stored procedure in sql server?

966

what are acid properties? : Sql server database administration

928

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

993

How to get @@error and @@rowcount at the same time?

984

How do I view views in sql server?

937

Explain throw statement in sql server 2008?

931

Is null in sql server?

939

What is a unique index?

883

Can you create a logon trigger in sql server 2005 express edition?

1031

What will be query used to get the list of triggers in a database?

954

What are the differences between char and nchar in ms sql server?

1008

What is the recovery model?

931