select count (*)as cnt from employees group by salary having cnt>3

 If you want to count the number of employees who have the same salary and have more than 3 employees with that salary, you can use the COUNT, GROUP BY, and HAVING clauses together. Here's how you can write the SQL query:


SELECT Salary, COUNT(*) AS cnt FROM Employees GROUP BY Salary HAVING COUNT(*) > 3;

This query will count the number of employees for each unique salary value, and it will only include those salary values where the count of employees with that salary is greater than 3.
at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

How to host application on server new way

 copy the htacess from public to root copy the server.php from public to root but rename to index.php htacess <IfModule mod_rewrite.c>...

  • what is directives
       s directives are modifying the html dom elements or oding some actions on dom elements Directives in Vue.js are special attributes that a...
  • convert asynchronous to synchronous function
      To convert an asynchronous function to a synchronous function, you'll need to remove the asynchronous behavior and ensure that the fun...
  • scopes in vuejs
     scopes are called as how can we access properties and methods that we called as scope component scope-> access method sor properties usi...