|
|
 NEW INTERVIEW QUESTIONS.COM 
 DATA WAREHOUSING INTERVIEW QUESTIONS
BUSINESS OBJECTS INTERVIEW QUESTIONS  DETAILS
NewInterviewQuestions.com - Home for World's Largest Interview Questions Website.
A D V E R T I S E M E N T
 Question |
clearly explain the difference between union and group
|
 Answer
|
The difference between union and group is as follows:
take two tables t1 and t2.in t1 we have columnss like a,b,c,d. and t2 has a,d,e,f.so union means t1 union t2 i.e getting result from both tables i.e a,b,c,d,e.,f
where as group performs on a indiviual column in a particular table.
Union:- is used to combine the data of more than two tables which are having same structure
Group:- is used to combine same type of data of a perticular column of table
Answered By: Chandra Date: 5/6/2008
© NewInterviewQuestions.com
|
If you have the better answer, than send it to us. We will display your answer after the approval.
Rate the above answer. Help us to know about the answer.
Please Note: We keep on updating better answers to this site. Subscribe to our newsletter to get notified when better answer is posted.
| Notify me when better answer is posted! |
A D V E R T I S E M E N T
|
|
|
Latest 10 Answers
|
|
ABAP is basic (technical) side of SAP. which helps other function of business sibe ex.financial,sales,inventory& human resource.
|
|
Cluster index work as a primary key and as we know in a single table only one primary key should be there....Hence only one records can take cluster index.
|
|
Select Employee.*, Department.* from Employee LEFT OUTER JOIN Department ON Employee.EmpId=Department.DeptId
|
|
Both are the connection object but SQLCLIENT using while connect with Sqlserver database and OLEDB using while connect with MS-access database and Oracle database.
|
|
Only 1 cluster index and 255 non cluster index.
|
|
Because it's used to read the data from the DB as Read-only manner, only forward direction not backward..hence its not supporting edit operation.
|
|
I will throw my wife because if my wife dies ican get another but mother is only one I cannot get another
|
|
When mistake is found by compiler is known as ERROR , when a mistake is found by tester while testing is a BUG and when mistake is found by the end user it is known as DEFECT.
|
|
Create customer code & transporter code, create sales order, checke the payment received then released order from Finance, delivery, billing, invoice.
|
|
Invoice is a request sent by vendor for the payment against services/goods with all the necessary details like - Price, Rate, Quantity, Vendor Name, Vendor Address, Unique Invoice Number (From Vendor), Terms & Conditions.
|
|
Rating
(3.7) By 3 users
Added
Views
Rate it!