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
- 7696 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
Any one send me sample question for multimedia testing with microsoft access database. I am having interview next week. Please post it or send me my personal e-mail. Thank You
please give information about ERP Projects and how V-model use in project
What is AGP?what is setup.inf?What are the ways to install driver?
What if the project isn’t big enough to justify extensive testing?
Our software designers use UML for modeling applications. Based on their use cases, we would like to plan a test strategy. Do you agree with this approach or would this mean more effort for the testers.
what is the main field of bugzilla which we fill to report bug to any developers???give some brief description??
Please anyone give answers for all below questions and help ? realtimers please and please share your knowledge.lot of questions left unanswered.
What type of questions will be asking for 2 years experience candidate in manual testing?
what are the test bugs
What is mean by incident logging system ?
Define performance and stress testing?
What is Independent Testing?
diff b/w desktop based testing & web application testing
What is quality center?
What are the bugs we cannot find in black box?
