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 9168If 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 4836Difference 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 7543I 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
1813I want expect first and last record remaining all records will be loaded into target? which transformations we can use?
6 13107i 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 15043different b/w Direct assigment and indirect role in bi security whn will go direct assignment
2 11128Post New CTS Interview Questions
What are Keyword and Data driven frameworks in Selenium RC
What are common risks at TK Maxx? And how to face?
How do you delete a corrupted file?
Why does php start with variables?
How can type-insensitive macros be created?
How to handle and retry the failed request due to poor network connection in angular 4?
Write python logic to count the number of capital letters in a file?
Is python better than c++?
What is swing and awt in java?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
How many tags are there in jsp?
How to use aggregation in mongoose?
Which files are required for theme?
What is Disk Balancer in Hadoop?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?