Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between cross join and Full outer
join?
- 1 Answers
- 7862 Views
- HP, Standard Bank, I also Faced
- E-Mail Answers
Answer / soma shaw
A cross join is a Cartesian join. for sets of A and B rows, you'll get a result of A * B rows. A full join will match all possible rows, meaning it will return AT MOST A + B rows.
| Is This Answer Correct ? | 18 Yes | 0 No |
Do you know what are the steps to process a single select statement?
Explain the different types of joins?
explain declarative management framework (dmf) in sql server 2008?
Which system table contains information on constraints on all the tables created?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
Can Having clause be used without Group by clause?
6 Answers CarrizalSoft Technologies, CSC, CTS,
How do you find the number of rows in a table?
What is a ddl statement?
What are points to remember while using the fillfactor argument?
two tables are there.1st table EMP has two columns ID and name and contains data 1,A 2,B 3,C 2nd table EmpSal has 2 columns ID and Salary Contains data -1,1000 2,5000 3,3000 Find name of employee having maximum salary ?
What is the difference between substr and charindex in the sql server?
-
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)
