Some Basic SQL Queries

1) Query to select Maximum Salary from a Table

Select Max (ActualSalary) from employees


2) Query to select Minimum Salary from a Table

Select Min (ActualSalary) from employees


3) Query to select unique values from a table

Select Distinct EmpStatusCode from employees


4) Query to select 6th highest Salary

SELECT TOP 1 ActualSalary
FROM (SELECT DISTINCT TOP 6 ActualSalary FROM employees
ORDER BY ActualSalary DESC) a
ORDER BY ActualSalary


5) Query to select total count from table

SELECT count (* or field name) from employees


6) Query for ascending order display

SELECT * from employees Order by LastName


7) Query for Descending Order display

SELECT * from employees Order by LastName DESC



8) Query to insert Values into a table

INSERT INTO Persons (P_Id, Last Name, FirstName)
VALUES (5, 'Tjessem', 'Jacob')


9) Query to update values in a table

SET EmpID =1000 WHERE LastName=’Rakesh’


10) Query to delete a value from a table

Delete from employees where EmpID=1000



If you know some basic queries other than this, kindly drop it in the comment section.

Importance of Resolution Testing

Few Days back we got a bug from our client when the application was in Production Server.They got java script error and blank page while accessing a particular menu. (Find the Screen shot below)

It was straightly forwarded to the development team by our project manager.
They tried many times to reproduce the issue but they can’t.At last as usual it came to our testing team and we also tried to reproduce the same and failed.

We tried in lot of scenarios and by changing the system environment also.
At Last we changed our screen resolution into 800 * 600 pixels and tried to access the same menu which was reported by our client and we got the same error this time.

At that day we learnt a lesson to test the application by changing the screen resolution.After that we had added this scenario into our lesson learnt document and also in Test Scenario document.

Many of us were aware of this type of Resolution Testing. But due to lack of schedule we missed to execute these scenarios and these things will become very big issues to the client.

So make sure to test the application by changing the screen resolution before delivering the application to the client.






If you have any feedbacks for this post, kindly drop it in the comment section

Testing Interview Questions

If you are going to attend an interview in Manual Testing, then you have to prepare for the following basic questions which were asked in many interviews.

1) Prepare about you and your professional experience. It will be within 3 to 5 minutes.
2) Prepare something about your company details
3) Your Roles and Responsibilities in your company
4) Prepare about your current project. You have to tell the Project title, Client of the project, Short Description about the project, how many modules are there in the project and which part you have involved in the project.
5) Your Daily Regular activities after entering and leaving from office?
6) Types of testing u have done in your experience?
7) What are the challenges situations you have faced?
8) What are Severity and priority and some examples?
9) What are all the achievements you made in your company in your role?
10) What are all the challenging defects you found?
11) What will you do to reproduce issues, if the developer says that he can’t able to reproduce?
12) How will you Communication within your team and stake holders?
13) What is the Difference between client server applications and Web Applications?
14) What is SDLC and explain about it?
15) What is STLC and explain about it?
16) Testing process you follow in your company?
17) What is Bug life cycle and explain about it?
18) Test case preparation and sample test cases?
19) What is Requirement traceability matrix and how will you do it in your company?
20) What is Defect traceability matrix?
21) How does a web applications works?
22) What is V- Model and explain about it?
23) What is the Difference between waterfall model and V MODEL?
24) What are all the Testing Techniques?
25) What is Boundary Value analysis and Equivalence partitioning and give examples?

If you people have more questions that will be asked in interviews, kindly add it in the comments section.