sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id where b.deptno=10; sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id and b.deptno=10; what is the difference on the above 2 queries?
3 10417If we execute an query in MLOAD it's ran successfully, my questions is after successfully ran MLOAD. In error tables we can see anything there! is it possible than what are they?
3 6154Difference between 4.7c and ECC 6.0 in security aspect? I tried in many website but still not able to find the correct one.
2 8642I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
2283I want expect first and last record remaining all records will be loaded into target? which transformations we can use?
6 15341i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 90 2 bbb 60 80 50 i want to execute every student highest mark in which subject my o/p like below studentid studentname sub3 sub2 1 aaa 90 2 bbb 80
12 18054different b/w Direct assigment and indirect role in bi security whn will go direct assignment
2 12342Post New CTS Interview Questions
What are advantages of .htaccess?
What is aws documentdb?
What Are The Different Types Of Instances Used In Amazon Ec2?
What are server side controls?
why dissolution multimedia profile of drug is important. what are the specifications for tablets ,capsules,powders etc
What is an algorithm in coding?
How do I update php?
What are two important objects of ADO.Net?
What are the advantages of database system?
What is css box sizing?
what are the instance properties in system properties?
What is the difference between system.text.stringbuilder and system.string?
Explain “row_number()” in sql server with an example?
List some ajax attributes.
What are the implications?