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
What is system stored procedures?
what are the core components of SSRS?
What do you understand by triggers?
What is difference between clustered index and non clustered index?
Which sql server is best?
Explain relational data?
What is filtered index?
Explain the third normal form(3nf)?
How to truncate the log in sql server 2012? : sql server database administration
How to declare and use cursor variables?
How will you make an attribute not process? : sql server analysis services, ssas
What is meant by referential integrity?
What is a trace frag? Where do we use it?
What do you mean by tablesample?
Explain what are the restrictions that views have to follow? : SQL Server Architecture