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

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

Question Posted / vaibhavi_dixit

Answer Posted / vaibhavi_dixit

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

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Define inner join? Explain with an example?

996

In which files does sql server actually store data?

904

what is the difference between openrowset and openquery?

1087

Explain what is scheduled job and how to create it?

955

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

962

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

968

Where are SQL server users names and passwords are stored in sql server?

1271

What are parameterized reports?

200

What are cursors in ms sql server?

1178

What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

980

what are acid properties? : Sql server database administration

997

Issues related in upgrading SQL Server 2000 to 2005 / 2008

1887

How to find tables without indexes?

1089

What is data compression? : sql server database administration

969

What programming language would you use to create embedded functions in ssrs?

184