Category Archives: MySQL

Database fundamentals : How does RDBMS’s support for multi-user environments enhance its advantages over other database systems?

Database fundamentals : RDBMS systems are designed to handle multiple users simultaneously. This support for multi-user environments enhances data integrity by ensuring that concurrent transactions do not interfere with each other. It provides concurrent access control, allowing multiple users to work with the data concurrently while maintaining the database’s integrity and consistency.

Database Fundamentals : In which database language would you find commands related to user privileges, like GRANT and REVOKE?

Database fundamentals : In the SQL (Structured Query Language) database language, commands related to user privileges, like GRANT and REVOKE, are used to manage access control and permissions for database objects. These commands allow database administrators to specify who can access or modify data within the database, providing a crucial aspect of security and authorization… Read More »

How to find duplicate rows from query ?

If you want to find duplicate rows from your table use the following query. SELECT column1,column2 COUNT(*) users GROUP BY column1, column2 HAVING COUNT(*) > 1SELECT column1,column2 COUNT(*) users GROUP BY column1, column2 HAVING COUNT(*) > 1 Following are steps : To test the above query on sample table Step1 : First of all you need a table (Assuming you have… Read More »