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
Answer / vaibhavi_dixit
select max(alias1.columnname) from table1 alias1
join table2 alias2
on condition
Is This Answer Correct ? | 2 Yes | 0 No |
What is the difference between drop table and truncate table?
what is checksum in sql server.........???
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?
What is RMS migrations?
What are the different types of columns types constraints in the sql server?
How do I start and stop sql server?
why we use cursor?
4 Answers CarrizalSoft Technologies, Melstar, TCS,
Which sql server table is used to hold the stored procedure script?
Can multiple columns be used in sql group by clause in ms sql server?
Relational calculus is what type of language?
what is cluster and nin-cluster index?