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
- 9168 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
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 white box testing, and what are the various techniques?
write the test senario on opening door in the flow diagram format
Write down ten test cases for below scenario: Increase the day by 1 and date format should be mm/dd/yyyy Conditions are : date should not be greater then 31 and date<1 month should not be greater then 12 and month<1 year should not be greater then 10000 and year<1 Thanks in advance
What is test plan and contents available in a test plan?
What r the functional testing u perform?
What are all the netwoking tools, hardware tools and software tools required for testing a web-based n client server applicatopn?
Explain the importance of agile testing?
Is anybody have the telecom systems test cases from start to end?
which of the following is not a coding defect? Option 1 Test harness defect Option 2 Data flow defect Option 3 Initialisation defect Option 4 Algorithmic defect
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
I am having 2 years of experience in Manual Testing, 2marrow I have an interview with a Company. Which type of questions they will ask me?How should I prepare for interview?Please guide me so that I will clear the interview.
.In languages testing, what is the fixed part and changing part?
what are the risks and contingencies u had in ur project?
how agile testing is performed and what are the related documents.
