What kind of join is join?
Answer / Rohit Kumar Bhadani
JOIN in SQL is a keyword used to combine two or more tables based on a related column between them. The most common types of joins are INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN.
| Is This Answer Correct ? | 0 Yes | 0 No |
Write a pl/sql script to display the following series of numbers: 99,96,93……9,6,3?
what is the difference between $message and $$message? : Sql dba
What is mdf ldf and ndf?
Which join is like inner join?
In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join.
how to include numeric values in sql statements? : Sql dba
What are inner outer left and right joins in sql?
I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.
how to convert character strings to dates? : Sql dba
Is microsoft sql free?
what is the difference between union and union all
14 Answers IBM, Luxoft, Oracle,
How to avoid duplicate records in a query?
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)