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
- 4213 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
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?
Can binary strings be used in arithmetical operations?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
What is cte (common table expression)?
What is nested transaction?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
What is resource governor?
How to sort the query output with order by clauses in ms sql server?
What does indexation mean?
What command do we use to rename a database?
How to make conditional sum in ssrs?
How to choose all records from the table?
Differentiate between a primary key and a unique key.
How to get the query of a table in sql server?
What is bcnf normalization form?
