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 5500I 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 10223Post New GE SQL PLSQL Interview Questions
- GE C Interview Questions (3)
- GE STL Interview Questions (1)
- GE OOPS Interview Questions (1)
- GE C++ General Interview Questions (3)
- GE MFC Interview Questions (1)
- GE Programming Languages AllOther Interview Questions (5)
- GE JavaScript Interview Questions (1)
- GE VB Script Interview Questions (1)
- GE Tcl Interview Questions (1)
- GE Microsoft Related AllOther Interview Questions (1)
- GE Oracle Call Interface (OCI) Interview Questions (1)
- GE Oracle Forms Reports Interview Questions (11)
- GE SQL Server Interview Questions (3)
- GE MySQL Interview Questions (1)
- GE DB Administration Interview Questions (1) GE SQL PLSQL Interview Questions (2)
- GE Operating Systems General Concepts Interview Questions (1)
- GE WinRunner Interview Questions (2)
- GE Load Runner Interview Questions (5)
- GE QTP Interview Questions (16)
- GE Test Director Interview Questions (4)
- GE Rational TestSuite Interview Questions (4)
- GE Silk Test Interview Questions (1)
- GE Automation Testing AllOther Interview Questions (2)
- GE Manual Testing Interview Questions (23)
- GE QA Concepts Interview Questions (3)
- GE Mobile Testing Interview Questions (1)
- GE Test Cases Interview Questions (6)
- GE Servers AllOther Interview Questions (1)
- GE JCL Interview Questions (1)
- GE Core Java Interview Questions (3)
- GE Informatica Interview Questions (3)
- GE Ab Initio Interview Questions (1)
- GE Data Stage Interview Questions (1)
- GE ETL Interview Questions (1)
- GE HR Questions Interview Questions (15)
- GE SAP ABAP Interview Questions (1)
- GE SAP SD (Sales & Distribution) Interview Questions (2)
- GE SAP FI-CO (Financial Accounting & Controlling) Interview Questions (1)
- GE SAP Security Interview Questions (2)
- GE SAP Netweaver Interview Questions (1)
- GE Siebel Interview Questions (1)
- GE Oracle Apps Technical Interview Questions (1)
- GE General Physics Interview Questions (1)
- GE Mechanical Engineering Interview Questions (8)
- GE Electrical Engineering Interview Questions (58)
- GE Electronics Communications Interview Questions (2)
- GE Instrumentation Interview Questions (3)
- GE Automobile Engineering Interview Questions (1)
- GE Engineering AllOther Interview Questions (5)
- GE Marketing Sales Interview Questions (2)
- GE Human Resources Interview Questions (2)
- GE Infrastructure Management Interview Questions (1)
- GE IT Management Interview Questions (1)
- GE Business Management AllOther Interview Questions (1)
- GE Taxation Interview Questions (1)
- GE Accounting AllOther Interview Questions (11)
- GE Call Centre AllOther Interview Questions (19)
- GE UPSC AllOther Interview Questions (1)
- GE POs Interview Questions (1)
- GE General Knowledge_Current Affairs Interview Questions (2)
- GE Tourism Hotel AllOther Interview Questions (1)
- GE Everything Else AllOther Interview Questions (1)
- GE General Aptitude Interview Questions (5)
- GE ISTQB Certification Interview Questions (1)
- GE Certifications AllOther Interview Questions (1)
- GE H1B Visa Interview Questions (1)
- GE USA Student Visa F1 Visa Interview Questions (1)
- GE JavaScript Code Interview Questions (1)
- GE GATE Interview Questions (1)
create a job that splits the data in the Jobs.txt file into
four output files. You will direct the data to the
different output files using constraints. • Job name:
JobLevels
• Source file: Jobs.txt
• Target file 1: LowLevelJobs.txt
− min_lvl between 0 and 25 inclusive.
− Same column types and headings as Jobs.txt.
− Include column names in the first line of the output file.
− Job description column should be preceded by the
string “Job
Title:” and embedded within square brackets. For example, if
the job description is “Designer”, the derived value
is: “Job
Title: [Designer]”.
• Target file 2: MidLevelJobs.txt
− min_lvl between 26 and 100 inclusive.
− Same format and derivations as Target file 1.
• Target file 3: HighLevelJobs.txt
− min_lvl between 101 and 500 inclusive.
− Same format and derivations as Target file 1.
• Rejects file: JobRejects.txt
− min_lvl is out of range, i.e., below 0 or above 500.
− This file has only two columns: job_id and reject_desc.
− reject_desc is a variable-length text field, maximum
length
100. It should contain a string of the form: “Level out of
range:
SOMEONE POST THE MODEL APTITUDE QUESTIONS FOR MRF TYRES PLz pLZ pLZ ..Very urgent
Hi, i am looking job in perfomance testing using Loadrunner can any body help me a project in any domine plz(Usah) chs_29@rediffmail.com
What is temporary table in sql server? Why we use temp table?
Describe your involvement in re-engineering down-sizing or cost containment processes?
what is the difference between valuation class and valuation category ?
if you run the app program all vendor open items are cleared but is it possible to reverse the again again open items please tell me the answer
What is the use of defining a newobject in the object repository "Define New TestOject". How to use this further. If we define new testobject, how can it recognizes the objects properties of any application.
Give examples of macro quoting function?
What are the differences between heap and stack memory in java?
WHEN IN ADJUST. GIVEN THAT THERE IS VALUE OF RS...., OBSOLESCENCE STOCK INCLUDED IN CLOSING STOCK RS.......,WHAT IS THE PROPER WAY TO SHOW IN INCOME STATEMENT AND POSITION STATEMENT.
pls send me HPCL model question paper for the post of officer trainee for mechanical engg. tnk u....
Do you acquire any knowledge on Computers? Elaborate it.
sir plz send me BPCL recruitment(Engineering Trainee Electronics & Communication) sample question papers & Topics as early as possible
Hello Frd's This is Mohd NaseerUddin. Is Anyone can help me out to findout a Accounting Peachtree 7.2 note's aswel as Focus notes also Plsssssss helpme out to find it. My E-mail id is mohd_naseeruddin43@yahoo.com
