Can some one please help with a query which will take only
max value of a column in a join.
- 2 Answers
- 3783 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vaibhavi_dixit
select max(alias1.columnname) from table1 alias1
join table2 alias2
on condition
| Is This Answer Correct ? | 2 Yes | 0 No |
What is the difference between upgrade and migration in sql server?
What is query cost in sql server?
What is the parse query button used for?
Can we add our custom code in ssis?
What stored by the model?
What is tempdb database? : SQL Server Architecture
what are the disadvantages of cursors? : Sql server database administration
can you tell me some sites name for sql server 2000 commands with example??? plz reply soon.
What is the difference between a stored procedure and a user defined function?
What is sparse columns of sql server 2008?
What is nonclustered index on computed columns?
What are the system database in sql server 2008?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
