In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join.
2 5341I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.
4 9963Post New GE SQL PLSQL Interview Questions
How to create Index to the table in the universe designer and how it improves the Query performence
How do you find the second largest element in an array of integers?
When will we go for multi-mapping?
How many rows can a mysql table hold?
With a phasor diagram show the effect of increasing the field current of a generator supplying a constant real power and connected to a grid system.
What are jsp and servlets?
Occasionally it is said that issuing convertible bonds is better than issuing stock when the firms shares are undervalued. Suppose that the financial manager of Decent Furniture Company does in fact have inside information indicating that the decent stock price is too low. Decent furniture earnings will in fact be higher than investor’s expectations. Suppose further that the inside information cannot be released without giving away a valuable competitive secret. Clearly, selling shares at the present low price would harm Decent’s existing shareholders. Will they also lose if convertible bonds are issued? If they do lose in this case, is the loss more or less than it would be if common stock is issued? Now suppose that investors forecast earnings accurately, but still under value the stock because they overestimate Decent’s actual business risk. Does this change your answer to the questions posed in the preceding paragraph? Explain.
Which rendering formats are affected by the pagesize properties?
How many columns are in access?
What are the major disadvantages of product grouping?
What is database migration in mysql?
How do you remove all elements from an arraylist in java?
How to get the title of the page?
How does the sodium-potassium pump present in the cell membrane work? What is the importance of this protein for the cell?
hello!my name is sheikh iam preparing for indian engineering servieces,please send me the old question papers..to sheikhshaazforjobs@gmail.com