from same table w ehave 500 50 for 66 members , 800 salary from 6 menbers, 7000 salary members , i need count greater than 3

 To count the number of employees who have a salary greater than 3, you can use a SQL query with the COUNT function and a WHERE clause to filter the results. Assuming your Employee table has columns named "Name" and "Salary," here's an example query:


SELECT COUNT(*) FROM Employee WHERE Salary > 3;

This query will count the number of employees whose salary is greater than 3. Replace Salary > 3 with the specific condition you need, such as Salary > 3000 if you're looking for employees with salaries greater than 3000, or adjust the condition based on your salary scale.

No comments:

Post a Comment

React -1 ( react with ravenndra kanchi)

 react with tool chanis 45 to 50 sessions core  after 50 sessions -> some tooll chains == react with type script mern stackaplication in ...