Interested to Buy Any Domain ? << Click Here >> for more details...
IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF
SELECT * FROM EMP,DEPT;
- 1 Answers
- 5541 Views
- I also Faced
- E-Mail Answers
Answer / shailesh
Cartetian product i.e. 8 rows will be returned.
| Is This Answer Correct ? | 26 Yes | 0 No |
how to delete an existing column in a table? : Sql dba
what are the differences between char and nchar? : Sql dba
What is relationship? How many types of relationship are there?
How does sql profiler work?
What is asqueryable?
How to write a query to show the details of a student from students table whose
How many types of database triggers can be specified on a table ? What are they ?
How much does sqlite cost?
how many tupples can insert in 1 second in sql
Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?
how can we submit a form without a submit button? : Sql dba
How to prepare for oracle pl sql certification?
-
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)
