SQL query: Find out the count of employee whose name is more than one time

5 pts.
Tags:
MySQL
SQL
SQL Query
In SQL, how do I find out the count of employee whose name is more than one time in a table?


Software/Hardware used:
A sentence is there i have to display the "text is present " if string great is present in that sentence
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    Sounds like homework. Post your code so far and we will take a look at it. This will help us point you in the right direction.
    135,465 pointsBadges:
    report
  • Subhendu Sen
    What database are you using now! Is it oralce/ sql server/ mysql/mssql or other. There are some changes in syntax of each database. Moreover, if this is related to assignment/ homework, better do it yourself by taking help from study materials.
    141,290 pointsBadges:
    report
  • carlosdl
    These are the topics you would need to study:

    • Group operations
    • Aggregate functions
    85,430 pointsBadges:
    report
  • ToddN2000
    Follow carlosdl's tips. You need to learn the basic construction of a SQL statement. This is a simple example. In life they get much more complex. The benefits of know proper SQL are worth the effort. If you still have trouble post you code and we can show you how to fix it.
    135,465 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: