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
- 8965 Views
- ADP, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Hello everybody, How many people do you think one sprint team can have in average?
can any one explain me briefly erp pharma project including all modules,like how to tell this project in interview in terms of s/w testing
Define performance and stress testing?
Usually customers won’t give all the requirements. How will you manage & collect all the necessary information?
What are the Major Functionality for a ATM machine ??
What is PBX Testing & What is Test coverage?
What is smoke test? Do you use any automation tool for smoke testing?
How does compatibility testing differ while testing in Internet explorer and testing in Firefox?
consider therez 1 land and it has mango trees in it, what are the tets cases or how will we count no of mangoes on all trees
what is the main field of bugzilla which we fill to report bug to any developers???give some brief description??
Can test condition,testcase and testscript help u in performing the static testing
What are the RBI rules has to follow by a bank for online precesseing. ?
types of reviews?Advantages of reviews? Diff between process and procedure? diff b/w verification and validation? diff b/w cmm,cmmi? exp tqm,gqm,iso,ieee? Roles and responsibilities of tester? Ricks,types of ricks? what r Quality factors?
what are your achievements in your organization ? Guyz very very urgent , help me
What are the typical risks that you identify during test planning and their mitigation plan and Contengency plan.
