Can some one please help with a query which will take only
max value of a column in a join.
- 2 Answers
- 3380 Views
- I also Faced
- E-Mail Answers
Answer Posted / debasish
select max(alias.colomnname) from table alias
join table alis on
<condition>
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
Explain features of analysis services?
Explain triggers in sql?
What is the difference between sdf and mdf?
What are the disadvantages of using the stored procedures?
Explain about Views?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
What is the difference between update lock and exclusive lock?
What is the purpose of data source?
How to backup encryption key ?
What is linked report?
What stored by the master?
How much space does sql server 2016 take?
What are system databases into sql server (2005/2008)?
How to create median function?
What are the different types of backups avaialabe in sql server 2005?
