How does a self join work?
No Answer is Posted For this Question
Be the First to Post Answer
I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?
a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.
Is inner join same as self join?
While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far?
what will be the output: select 1 from emp union all select 2 from emp;
Is sqlite good enough for production?
Is sql port 1433 encrypted?
What is user defined functions?
select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?
Compare sql & pl/sql
Is sql free?
have table with two columns with datatypes as number and varchar and the values in A column like 1,2,3 AND B column values like a,b,c. now need to display data in a single column as 1,a,2,b,3,c.
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)