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 table level trigger?

1029

What is GUID in sql server?

1173

Differentiate between delete and truncate.

1068

What is the purpose of the tempdb database?

1006

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1142

How many types of database relationship in sql server?

1061

What are the mathematical functions supported by sql server 2005?

1077

What is primary key index?

987

what is a self join? : Sql server database administration

1053

What are page splits?

1004

What do you understand by recursive stored procedure?

944

How fixed length strings are truncated and padded?

988

Explain user defined views?

973

What are differences in between sql server 2012 and sql server 2016?

1055

Explain tables in SQL Azure?

120