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

What is default constraint?

940

How to make conditional sum in ssrs?

175

How to retrieve error messages using odbc_errormsg()?

996

What happens if null values are involved in bitwise operations?

971

When would you use the stored procedures or functions?

952

Why use identity in sql server?

1024

What are alternate keys?

942

What is the purpose of data source?

967

Does the order of columns in update statements matter?

865

What are the advantages of stored procedure in sql server?

840

Difference between LEN() and DATALENGTH() in sql server ?

1064

What are pessimistic lock and optimistic lock?

1007

Give me a SQL Query to find out the second largest company?

1127

Explain transaction isolation levels in sql server?

1050

What the different components of Replication and what is their use?

1022