Can some one please help with a query which will take only
max value of a column in a join.
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 data modification?
How to choose all records from the table?
What is indexed view?
What is it unwise to create wide clustered index keys?
What is the significance of master, tempdb and model databases?
How do I connect to sql server database?
What is clustered primary key?
Explain how you can deploy an SSRS report?
Does sql server use t sql?
What is difference between views and tables?
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
What are policy management terms?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
What is normalization of database?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?