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
- 4295 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
can an automatic recovery be initiated by a user? : Sql server administration
What are basics of policy management?
Where do you find the default Index fill factor and how to change it?
How many types of attribute relationships are there? : sql server analysis services, ssas
What does normalization do to data?
How to select some specific rows from a table in ms sql server?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
Are resultset updatable?
How to list all objects in a given schema?
How to rebuild all indexes on a single table?
Tell me about normalization in DBMS.
What happens if date-only values are provided as date and time literals?
Would you store your query in a ssrs report or a database server? State the reason why?
What is the contrast between sql and mysql?
What is a performance monitor?
