Can some one please help with a query which will take only
max value of a column in a join.
Answer Posted / 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 View All Answers
How to search for a string in all stored procedure in sql server?
Explain how to use linked server?
What is the stuff and how does it differ from the replace function?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
Explain trigger and trigger types?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
What are the different types of lock modes in sql server 2000?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
Define Wed Edition in SQL Azure?
What is reference section?
What is an etl file?
What are examples of triggers?
What are different types of roles provided by ssrs?
what are database files and filegroups? : Sql server database administration
If a table does not have a unique index, can a cursor be opened on it?