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 / 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


Please Help Members By Posting Answers For Below Questions

Explain the different index configurations a table can have?

940


What is the purpose of data source?

1030


How display code or Text of Stored Procedure using Sql query in Sql Server ?

1141


What is a db view?

892


What is query cost in sql server?

993


How to create a simple stored procedure in ms sql server?

1024


Which are ddl commands?

1038


What is Extended user-defined?

955


What is intellisense?

1045


List all the types of user-defined functions?

1093


What is the difference between mysql and sql server?

1011


Define outer join in sql server joins?

928


What are the events recorded in a transaction log?

993


What are the different types of sql server replication? : sql server replication

1260


How to stop log file growing too big?

1012