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).
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 the difference between Desktop testing,Client/server testing and webapplication testing
What do you plan to become after say 2-5yrs (Ex: QA Manager, Why?)
What r the things,u prefer and prepare before starting testing?
whats main working for tester. and developer, and prject manager.
What is Online gaming, payment gateway development, hosting and custom software development services.
What is reverse engineering?
What is bug severity?
Should testing be done only after the build and execution phases are complete?
Name three reasons why the tester may choose to record in Context Sensitive mode.
.In languages testing, what is the fixed part and changing part?
How a test engineer will convince a test lead when he didn't approve the bug as a report ???
When have you had to focus on data integrity?
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
write test condition for testing SMS service of a mobile phone maximun length is 100 character while sending and 80 character for receiving write test scenarios do not write test cases
Hi, I want "Intergraph" placement papers for experienced people which was conducted recently in Hyderabad. Thanks, Purnima.