What is row_number () in sql?
No Answer is Posted For this Question
Be the First to Post Answer
What is trigger and how to use it in sql?
Is foreign key mandatory?
How do I turn a list into a table?
What is constant in pl sql?
What does plvtab enables you to do when you showthe contents of pl/sql tables?
What is the difference between inner join and left join?
What are the advantages of pl sql?
display null value rows with out using null function?
How do I view an execution plan in sql?
What is record type in pl sql?
How can a function retun more than one value in oracle with proper example?
4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;
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)