Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / sudeesh r

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

How do clustered indexes store data?

0 Answers  

How much space does sql server 2016 take?

0 Answers  

What protocol does sql server use?

0 Answers  

What is trace flag in sql server?

0 Answers  

What are the pre-defined functions in the sql server?

0 Answers  




Relational calculus is what type of language?

0 Answers   HCL,

How to maintain a fill factor in existing indexes?

0 Answers  

Explain various On-Delete options in a DB table. Which is the default option?

0 Answers   Akamai Technologies,

What is a document index?

0 Answers  

When do you create cluster and noncluster index?

5 Answers   Satyam,

What are Magic Table?

34 Answers   3i Infotech, Digiweb, Evalueserve, NIIT, PL,

What is difference between unique and primary key?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories