Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.

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


Please Help Members By Posting Answers For Below Questions

What is data modification?

1015


How to choose all records from the table?

1102


What is indexed view?

1019


What is it unwise to create wide clustered index keys?

1040


What is the significance of master, tempdb and model databases?

1126


How do I connect to sql server database?

1060


What is clustered primary key?

1077


Explain how you can deploy an SSRS report?

155


Does sql server use t sql?

1066


What is difference between views and tables?

1071


As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1170


What are policy management terms?

1036


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5974


What is normalization of database?

1171


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?

2184