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

Â Explain what is sql override for a source taLle in a mapping?

945

What are recommended options to be used while using db mirroring? : sql server database administration

1069

How do you delete a data source?

953

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

888

Describe in brief authentication modes in sql server.

967

how will add additional conditions in sql?

1013

What is mapping schema?

983

Is resultset an interface?

903

How to download and install sql server 2005 books online?

1085

What is the need for indexing?

887

What is a database table?

925

Can two tables share the same primary key?

856

What are different types of data sources?

935

What command do we use to rename a database?

1011

Explain what is meant by replication of database?

957