Interested to Buy Any Domain ? << Click Here >> for more details...
Can some one please help with a query which will take only
max value of a column in a join.
- 2 Answers
- 4193 Views
- I also Faced
- E-Mail Answers
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 change data capture (cdc) in sql server 2008?
How can I check that whether automatic statistic update is enabled or not?
Can a synonym name of a table be used instead of a table name in a select statement?
how to use DTS package in 2000,2005,2008 in sql server
Why de-normalization required?
What is partition, how will you implement it? : sql server analysis services, ssas
How do I view a stored procedure in sql server?
Indexes are updated automatically is the full-text index also updated automatically?
Explain about Views?
How to recompile stored procedure at run time?
Is there any difference between primary key and unique with the not null condition?
How to find out the list schema name and table name for the database?
Why should you use or avoid select * statements?
Introduction of rollup clause using sum and group by clause?
How to insert data into an existing table?
