-- If experience and Salary is stored as monthly, if they are stored yearly basis then you can add the Logic to get the monthly salary and experience in monthSELECT Name, Experience, SalaryFROM tblEmployeeWHERE Experience > 10 AND Salary > 15000;SELECT * FROM tblEmployeeWHERE Name LIKE '[^aeiouAEIOU]%[aeiouAEIOU]';
If experience and Salary is stored as monthly, if they are stored yearly basis then you can add the Logic to get the monthly salary and experience in month
SELECT
Name,
Experience,
Salary
FROM tblEmployee
WHERE Experience > 10 AND Salary > 15000;
SELECT
*
FROM tblEmployee
WHERE Name LIKE '[^aeiouAEIOU]%[aeiouAEIOU]';
Comments
Post a Comment