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
- 7298 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
what is mean by impact analysis ,how we used to select regression TC using this?
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
What is Windows Test Technologies? Where i will get all information of it.
What are the advantages of automation over manual testing?
1.How to maintain the Bug status Report? 2.What is project based Company and product based company?
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
why use caffine for HPLC calibration ?
write test case for gmail sign up page ?
In our project, we use Withdrawal Indent, we are confused to use heading as "Withdrawal Indent" or "Withdraw Indent". Please suggest me which one to use ASAP, Thanks in advance
can anyone tell anyone is providing training for CSTE exam in bangalore? and can u send some links related to this?
hi, this is geetha, i have one doubt regarding the vulnerability testing. For sql injection testing is there any need for the tools to be installed. If it is what is tool and what is the method to test in sql injection testing. Plz Guide me
ive been looking for a junior tester job for quite some time now, but most company keep requisting for experienced staffs, but if i dont start from somewhere how do i get the experience
What are all the scenario for 1.google analytics 2.api 3.paypal
Describe your experiences with code analyzers.
Which test cases are written first: white boxes or black boxes?
