Interested to Buy Any Domain ? << Click Here >> for more details...
about join
- 2 Answers
- 4892 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mala yadav
select command is used to fetch the result from the table ,
but of u want the combine results from more than 1 table
then in this case we use JOINS rather than a single table
select statement.
In joins u can join upto 2 to 61 tables to get tha required
result.
joins are of 5 types
- inner join
- self join
- cross join
- left outer join
- right outer join
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / vishal
if u donot know join means u always working in one table but
always single table is not enough to give the result than
comes the concept of joins in which two table we join must
have a column same on the basis of the table are join. join
are of various type such as left outer, right outer ,inner
join etc
| Is This Answer Correct ? | 0 Yes | 0 No |
What is mysql primary key?
What are date and time data types?
How many ways to get the current time?
Why MySQL is used?
What is orm in mysql?
Explain the difference between primary key and candidate key in mysql?
Is mysql a server?
In mysql, what is joins? Explain
What is unique key in mysql?
What is row locking in mysql?
How big is a blob mysql?
How do I automate a backup in mysql?
-
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)
