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 happens if null values are involved in boolean operations?

559

Can multiple columns be used in sql group by clause in ms sql server?

554

What is the difference between mysql and mysqli?

587

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

621

Explain how to send email from sql database?

569

Explain filtered indexes benefits?

598

What is the command to change the recovery model?

571

Explain the third normal form(3nf)?

526

Describe in brief databases and sql server databases architecture.

533

What is report subscription?

What is a print index?

502

Does partitioning improve performance?

495

Explain user defined views?

580

What is the difference between clustered index and primary key?

508

Mention the different authentication modes in sql server.

539