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.
- 2 Answers
- 4223 Views
- I also Faced
- E-Mail Answers
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 instead of dml trigger?
What is primary key and example?
What is equi join with example?
How important do you consider cursors or while loops for a transactional database?
What is thr feature of change data capture?
Which are the important points to note when multilanguage data is stored in a table?
Explain atomicity?
What is the difference between stored procedure and user defined functions?
What are the different type of replication in sql server?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
Do you know the capabilities of cursors?
Explain the usage of floor function in sql server.
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
