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
- 7274 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
Can anybody help i put the pharma and bank project in my resume, but i dont know what to tell about them, any body tell the where can i get the information about them,what i need to tell about these applications,please help me
Can anyone write test cases on google account creation page in the testing template format , urgent pls and explain if possible how to execute also
how can u prepare the test plan?
What is unit level testing?
What are the main key components in web applications and client and server applications?
What are the two main categories of software testing?
what is the general pattern of explanation of projects in interview, can u ans me plz.......... ex: online banking application
write a testing stratgy \ approach for a product that you are use every day (e.g gmail, out look etc)
How to explain the Insurance project in the interview?
What is a code walk through?
What is PBX Testing & What is Test coverage?
what is scrum how with ex?
What is XML Testing? Do we have any tools to test the XML? Please let me know.
What types of testing is specifically important for web testing?
What is a defect?
