Can some one please help with a query which will take only
max value of a column in a join.

Answers were Sorted based on User's Feedback



Can some one please help with a query which will take only max value of a column in a join...

Answer / debasish

select max(alias.colomnname) from table alias
join table alis on
<condition>

Is This Answer Correct ?    6 Yes 1 No

Can some one please help with a query which will take only max value of a column in a join...

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

More SQL Server Interview Questions

What is the difference between drop table and truncate table?

0 Answers  


what is checksum in sql server.........???

0 Answers   TCS,


how to insert the values in 5 table at a time Using any single statement ?

6 Answers   Infosys, Value Labs,


What is the syntax for encrypting a column in SQL Server?

0 Answers   MindCracker,


What is RMS migrations?

0 Answers   Satyam,


What are the different types of columns types constraints in the sql server?

0 Answers  


How do I start and stop sql server?

0 Answers  


why we use cursor?

4 Answers   CarrizalSoft Technologies, Melstar, TCS,


Which sql server table is used to hold the stored procedure script?

0 Answers  


Can multiple columns be used in sql group by clause in ms sql server?

0 Answers  


Relational calculus is what type of language?

0 Answers   HCL,


what is cluster and nin-cluster index?

4 Answers  


Categories