What is a Join in SQL Server?
Answers were Sorted based on User's Feedback
Answer / guest
Join actually puts data from two or more tables into a
single result set.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / simran_8185@rediff.com
joins is one of the facility provided to retrieve the data
from one or more than one tables simultaneously bt there
should be data intergrity among those tables.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / radhakrishnan
Join:
we are develop the table based on normalization
concept.data stored different table based on constraint.
when we required data from multiple table we need to use
Join clause.
we can use one or more than table in join caluse.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is difference between commit and rollback when used in transactions?
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
What is bcnf normalization form?
What authentication modes does sql server support?
What is change tracking in sql server?
What are entities and relationships?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
What is sql or structured query language?
Delete duplicate records from the table?(Table must have unique id)
7 Answers TCS, Thomson Reuters,
What do u mean by orphan users, how will u list them in the DB
What are the 2 types of classifications of constraints in the sql server?
tell me the disaster recovery plan
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)