What is a join and their types?
Answers were Sorted based on User's Feedback
Answer / s.chithiravelu
Join can be defined as an operation that includes the
retrieval of data from more than one table at a time.
Various Types of Joins:
Inner Joins
Outer Joins
Cross Joins
Equi Joins
Natural Joins
Self Joins
| Is This Answer Correct ? | 4 Yes | 0 No |
How to find Duplicate Records In table?
when would you go for denormalization? : Sql server database administration
Explain transaction server isolation?
What are the components of dbms?
List out the differences between global and local temp tables in sql server?
Explain system scalar functions?
what are batch in sql server?
Is truncate a dml command?
What is the difference between rank and dense_rank?
What is an indexing strategy?
Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz
How do we get current date in SQL Server 2000, Oracle, MS Access?
Oracle (3253)
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)