When to use inner join and left join?
No Answer is Posted For this Question
Be the First to Post Answer
table name: prod there are three fields in the table that are 1.proddate 2.prodQty 3.model Day wise prodQty is stored in the table prod write a query to display total prodqty in the year 2004 april.
What is the difference among union, minus and intersect?
how to shut down the server with 'mysqladmin'? : Sql dba
Can %notfound return null after a fetch?
What is a join?
how to get a list of indexes of an existing table? : Sql dba
Why do we use function in pl sql?
Is subquery faster than join?
How to create a table using constraints... IF i change the PARENT KEY value ,then CHILD KEY table will also to change in the another table... plz reply ur answers @ mak2786@gmail.com Arunkumar
which types of join is used in sql widely? : Sql dba
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
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)