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

How to avoid cursors?

3 Answers   CarrizalSoft Technologies, HP,

How to find the last update record in SQL Server?

4 Answers  

What do you mean by sql server 2005 express management tools?

0 Answers  

Which trace flags are enabled in sql server?

0 Answers  

What is join and name different type of joins?

0 Answers  




As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

0 Answers  

What is difference between Datepart() and Datename() in SqlServer?

0 Answers   Infosys,

What are the pros and cons of creating extended stored procedures?

1 Answers  

What is default port number for sql server 2000?

0 Answers  

What are the system database in sql server 2008?

0 Answers  

What have included columns when we talk about sql server indexing?

0 Answers  

What do you understand by physical_only option in dbcc checkdb?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories