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

how can a database be repaired? : Sql server administration

1017

How to write a query with an inner join in ms sql server?

1094

What are security principals used in sql server 2005?

1037

What is the difference between a view and a stored procedure?

1089

Explain how to use linked server?

1031

What is the full form of ddl?

965

How to delete exactly duplicate records from a table?

1110

What is difference between equi join and inner join?

1038

How do you make a trace?

1073

what is the difference between a primary key and a unique key? : Sql server database administration

1041

How do I uninstall sql server 2014?

985

Where actually sql azure database is hosted?

165

Distinguish between commit and rollback?

1011

Will sql server 2005 allow you to reduce the size of a column?

1055

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

1036