Oracle query to get column value and count of overall rows/results

By gunnalagDataBase

 

select users.email, count(*) from users, user_pwd_history where email like ‘%govardhan%’ and users.USR_ID = user_pwd_history.USR_ID group by users.email

 

image

By gunnalag

You might also like:

Unable to detach SQL database: "The database is in single-user mode, and a user is currently connected to it."

Implementing Desktop Theme Look and Feel for XenApp 6.5 Applications on Windows Server 2008 R2

Move WordPress Blog from AWS Instance to GoDaddy Managed WordPress Hosting

Leave a Reply

Your email address will not be published. Required fields are marked *