What is equi-join?
Answer / aryasen vaikom
An equijoin is a join with a join condition containing an
equality operator ( = ). An equijoin combines rows that have
equivalent values for the specified columns.
Eg: select * from emp,dept where emp.deptno=dept.deptno;
| Is This Answer Correct ? | 9 Yes | 1 No |
Explain what are super servers?
What is database partition key?
What are the five important software components of a database management system?
Define scalar functions.
what do u mean by canvases and alerts?
What is system r? How many of its two major subsystems?
What is a key in database?
What is hot backup (in case of oracle)?
If an UNIQUE KEY constraint on DATE column is created, will it accept duplicate values?
determine the minimum salary of the employee and his details who join on the same date
What is the purpose of normalization in dbms?
What are databases what are the uses of databases?
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)