How to find the list of users and their count of occurrence in a table in Oracle

-
select user_id , count(user_id) from t_gsa_session_details_ratepro where login_time between '2025-01-01 00:00:00.000' and '2025-07-03 00:00:00.000' group by user_id having count(user_id)>=1 ;

Comments

Post a Comment

Popular posts from this blog

-
Image
EASY DEPLOYMENT IN TOMCAT SERVER TAKE A BACKUP OF WAR FILE FROM PROD TO Desktop 1) sudo -i 2) systemctl stop tomcat_ratepro_app [ CHECK APPLICATION IS WORKIKNG] 3) cp -r /apps/ratepro/ratepro_app/webapps/RatePro-App-1.0.0.war /home/gehc-cloud/Bkp/Prod_bkp_on_18Jan2025/ 4) cp -r /apps/ratepro/ratepro_app/webapps/RatePro-App-1.0.0 /home/gehc-cloud/Bkp/Prod_bkp_on_18Jan2025/ 3) rm -rf /apps/ratepro/ratepro_app/webapps/RatePro-App-1.0.0.war;rm -rf /apps/ratepro/ratepro_app/webapps/RatePro-App-1.0.0 4) cp -r /home/gehc-cloud/GSA_To_Deploy_Files/RatePro-App-1.0.0.war /apps/ratepro/ratepro_app/webapps 5) chmod -R 777 /apps/ratepro/ratepro_app/webapps/RatePro-App-1.0.0.war 6) systemctl start tomcat_ratepro_app [RatePro-App-1.0.0 FOLDER WILL BE CREATED] 7) tail -100f /apps/ratepro/ratepro_app/logs/catalina.out 8) \cp -r /home/gehc-cloud/GSA_To_Deploy_Files/dist/* /apps/ratepro/ratepro_app/webapps/RatePro-App-1.0.0 9) chmod -R 777 /apps/ratepro/ratepro_app/webapps/RatePro-App-1.0.0 ...
Read more
-
  Like the King commands... When thinking of commands in Linux, I am reminded of the old stories of kings and military leaders who issue orders to their subordinates, expecting them to be executed promptly and accurately. Just like the king's command, a Linux command must be carried out in a timely and precise manner to achieve the desired result. Similarly, when we use commands to instruct our computers, we are telling them to perform specific tasks quickly and accurately, with results we are awaiting. Commands like "ls" or "ps -f | grep '.txt'" are common examples we use daily. These commands simplify our lives, and just like the orders of a king, they are often crucial and lawful. I’m referring to the way we use Linux commands to execute tasks and view their results. Linux is a powerful and wonderful operating system that presents its results in a structured and informative manner. However, mastering these commands and understanding their outputs requ...
Read more

Why to do a POC (Proof Of Concept)

-
 Proof Of Concept or POC POC or Proof Of Concept is done for the following reasons : 1) Less Waste Of Resources: POC's prevent you from dumping resources into projects that are unlikely to succeed. 2) More Funding from Clients : Investors are more likely to fund a project that has been proven viable. 3) Better Planning : A POC will make you think about project logistics before you even get started. 4) Fewer Road Blocks : Challenges to viability will stick out to you when writing a POC and can inform project direction Some snippets on POC's  1) POC  helps us to determine whether an idea is feasible before developing it in to a product. 2) Prototype : Prototype is a model of your product that can be tested to provide an idea of how it will function  3) Minimum viable product : An MVP is refined version of your prototype that's tested to identify minor issues and create the final product.
Read more