Interested to Buy Any Domain ? << Click Here >> for more details...
An employee table, with the columns id, name, sal and
dob.Query to select emp names of all highest salaries(there
are 4-5 people having the same salary which happens to be
the highest).
- 5 Answers
- 9023 Views
- ADP, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sujan thota
select name from emp where sal=(select max(sal) from emp)
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / varun b n
select * from emp where sal = (select Max(sal) from emp)
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / n. pavankumar
select * from emp where sal in (select max(sal) from emp)
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / naveen kamatam
select ename, salary from emp e
where 4 > (select count(distinct salary)from emp where
Salary > e.salary)
it will fetch top 4 high salary records
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / n@n!
emp table= emp;
column id =column_id;
name = name;
sal= sal;
dob= dob;
select top 1 name,sal,column_id,dob from emp order by sal
desc
while u run this query only one row was effected which
shows employee taken highest salary along with details like
column id,dob,name,sal.
if u want 5 employees list then replace top 1 by top 5
plz let me know if it was wrong (along with ur
query)...................
| Is This Answer Correct ? | 0 Yes | 5 No |
you will be given a program and asked to write the Test Data and expected output for the same. for eg: there is a program which returns the sum of largest two numbers in an integer array.
friends i know what is regression testing but i need an real time example from any of the projects..
1) Test summary contains ? 2) Requirement Tracebility means ? 3) Test Effort contains ? 4) Test Planning Productivity ? 5) Metrics should be caluclated ? 6) Interest rate Rsik is a type ? 7) Test analysis and Design process task? 8) secured loan is a part of Liability (or) assest in a balance sheet? 9) Money Market means? 10) a ------ specifies all of the terms of a loan and the obligations borrower ? 11) what is a primary market is ? 12) Quality of Testing measure with ? 13) Company has a share with facevalue 10 rs/- and NAV of 37 after comapny has given Dividend of 35 % then How much NAV become ? ( I don't know what is NAV means, question overall Idea I am giving not 100% perfect ) the potions for these are 1) 33 2) 33.50 3) 37 4) 42 14) one compay has taken 10 million loan from a bank for a Interest rate is 10 % and base amount is 0.4% so how much they had paid monthly Emi ? they provideansews like 1) 100000 2) 114000 3) 140000 4) 104000 Remaing questions I not remember.
How to conduct Regression Testing Manually?
Where we save the bugs?
Q-1 WHAT IS USE CASE? Q-2 Test cases cannot be developed with system users and designers as the use cases are being developed? true or false Q-3 WHAT ARE DIFFERENT TYPES OF INCREMENTAL TESTING? Q-4)The cost of fixing a fault a)not important b)increses the later fault is found c)decreses the later fault is found d)can never be determined
how is market for testing in banglore,chennai,pune,delhi?
which are the mandatory fields in QC while rising new bug??
How would you build a test team?
what statements did Philip Crosby use to capture the essence of the Quality Assurance discipline?
Hi frnds,im roopesh. i got job in an MNC company on FAQ experience(2.6yrs)..though i know the subject,but i dont know the real time process in a company. so pls can any one tell me vat is the work that i get first & what should i do ? in starting day ven i enter into company vat is environment there ? so pls frnds send the answer soon & give me support plzz..thanking u all.....
What is Error Feeding?
Automation Testing 
