Interested to Buy Any Domain ? << Click Here >> for more details...
He has given table attributes-
empid,empfirstname,emplastname,MangerID.And he asked write
query to display empfirstname and mangername?
- 3 Answers
- 8570 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / sneha.va
Suppose 2 tables;
Employee : having columns
empid,empfirstname,emplastname,MangerID
Manager : ManagerID, Managername
SELECT A.EMPFIRSTNAME,B.MANAGERNAME FROM EMPLOYEE A INNER
JOIN MANAGER B
ON A.MangerID = B.MangerID
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Hello. I am not here to answer your question. I jus found a job as software QA engr. And i am totally new to software testing. So can someone pls help me in the following scenario? there is this registration screen, and it contain: One textbox called Nickname which only accept alphanumerical One textbox called Contact which only accept numerical, One textbox called Email which can be filled with alphanumerical and symbol and One button called Register now becos there is so many textboxes, where i can filled with alphabet, number, symbol, "just space", leading zeros, leading space. there will be lots of combination. can someone pls help.. i will be appreciated if u can post the test case of the scenario i mentioned. Lots of Thanks
What is Stability and Performance Testing in Testing the TV
could u pls anyone tel me .."which is the best instute that provides eficient practical knowledge and also real-time oriented knowldge to do a project in manual and automation testing..in hyd" pls send me to dis mail-id if u find any..? sinducute17@gmail.com
Describe your experiences with code analyzers.
What are the major components of Perf Test Report?
Diffrernce between client server testing and web server testing.
10 scenarios for security testing using gmail applications?
I have an UI issue "please fill out this field" pop up in firefox browser keeps scrolling with the page is it valid???
what is mean by impact analysis ,how we used to select regression TC using this?
What is mean by multi-threading testing?
Negative test cases for phone camera
Hi guys,I have 3+ years of exp in manual testing in a bangalore based MNC company.I Like to jump in chennai.So please if u know any jobs in chennai firms please let me know in my email-id. anbarasu2k@rediffmail.com. cheers, anbarasu.
What do you plan to become after say 2-5yrs (Ex: QA Manager, Why?)
what are the templates for daily,weekly and monthly reports? plz reply ASAP.
how to write defects in excel sheets when defects occured
