how to get top two salaries from employee tables
Answer Posted / maruti
select max(sal)
from emp
where sal < (select max(sal) from emp);
with this query u ll get second largest sal of that table
if u want to know max (sal) then it ll be...
select Max(sal)
from emp;
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is test startegy?
How to write test cases for nevigating menus? Ex. Course -Topics -Subtopics
IF ASCII_CODE_OF_ENTERED_CHAR is less than 44 THEN reject it ELSE IF ASCII_CODE_OF_ENTERED_CHAR is greater than 56 THEN reject it ELSE it's a digit, so accept it Which one of the following sets of ASCII codes do you use to test the sample code above WITHOUT redundant coverage?
What are the possible test scenarios around AVS check of any credit card? (Testing through payment gateway online) (What are the fields we should check while checking AVS and CVV)
What r all the security problems u r facing & the measures taken to solve.
What is meant by entry criteria and exit criteria in software testing?
Do you know anything about Set Top Boxes?
How to do integration testing on duster......
What types of documentation are used in qa?
what are the different methods to test a product in 'Japanese' language? NOTE:User is unable to perform basic functionalities while using the app..(copy, paste, text selection etc.)
Diffrence b/w functional testing,functionality testing,system testing?
I am DD. I am working as a Tester in e-learning company? IS there scope for content testing? or i have to change to software testing. pls guide me...
Can list out some disadvantages of manual testing?
What are testing techniques? What is difference between general and specific?
Unit Testing can be done by using Nunit?