1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / sudeesh r

Answers were Sorted based on User's Feedback



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

Answer / debasish

select max(alias.colomnname) from table alias
join table alis on
<condition>

Is This Answer Correct ?    6 Yes 1 No

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

Answer / vaibhavi_dixit

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

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Is a primary key unique?

0 Answers  

What is Online Index Rebuild Operation?

1 Answers  

how can i view structure of table in sql server? tell me that query.

10 Answers  

How do you rename a table in sql server?

0 Answers  

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

0 Answers   Informatica,




Mention the differences between sql server and mysql.

0 Answers  

What is ms sql server index?

0 Answers  

How do you know if sql server is running on your local system?

0 Answers  

What is difference between getdate and sysdatetime in sql server 2008?

0 Answers  

How reterive duplicate value in SQL?

6 Answers  

Can the query output be sorted by multiple columns in ms sql server?

0 Answers  

How to Check Whether a Global Temporary Exists in a SQL Database or not?

2 Answers  

For more SQL Server Interview Questions Click Here
Categories