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
- 9223 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 are the different levels of manual testing?
What's the relationship between environment reality and test phases?
What r the domain for pharma, interview if they ask about phrma application, what need to tell, is there anybody have screens or any information please tell me and if have URL let me know please.
tell me brief about your project? please help me how to explain the project what is the flow? my current project is ERP domain web based application. please help me
How do you estimate white box testing?
What is Windows Test Technologies? Where i will get all information of it.
Tell me a critical defect in which your Client,PM,PL appreciate on you
. Is any graph is used for code coverage analysis?
Please anyone give answers for all below questions and help ? realtimers please and please share your knowledge.lot of questions left unanswered.
What does 100% statement coverage mean?
Tell some examples of bug severity and bug priority?
What is the negative testing and example
What is quality center? What are the modules of quality center?
Explain the advantages of automation over manual testing?
Can you explain an application boundary?
