What's the difference between inner join and left join?
No Answer is Posted For this Question
Be the First to Post Answer
check whether all the emp numbers are indeed unique.
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
How to fetch common records from two tables?
When should I use nosql database?
How can I pass the inner procedure value to outer procedure ?
What is a full join?
Write a query to get last 10 records from the table.
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
What type of join is sql join?
What is the difference between an inner join and an outer join?
Can we have two clustered index on a table?
What is a constraint. Types of constraints ?
5 Answers Accenture, BirlaSoft,
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)