MySQL Questions Asked in Companies

mysql> SELECT DISTINCT columnname FROM tablename; To show unique records in MySQL, you can use the DISTINCT keyword in a SELECT statement. Here’s an example: sql SELECT DISTINCT column1, column2, … FROM your_table; Replace column1, column2, … with the columns for which you want to retrieve unique records, and your_table with the actual name of … Read more

mysql> SELECT * FROM tablename WHERE name like “sonia%” AND phone_number = ‘9876543210’ limit 1,5; To show all records starting with the letters ‘sonia’ and the phone number ‘9876543210’ limited to records 1 through 5 in MySQL, you can use the following SQL query: sql SELECT * FROM your_table_name WHERE column_name LIKE ‘sonia%’ AND phone_number_column … Read more

mysql> SELECT * FROM tablename WHERE name like “sonia%” AND phone_number = ‘9876543210’; To retrieve records in MySQL that start with the letters ‘sonia’ and have the phone number ‘9876543210’, you can use the SELECT statement with the LIKE operator for the name and a simple equality condition for the phone number. Here’s an example … Read more

mysql> SELECT * FROM tablename WHERE name != “sonia” AND phone_number = ‘9876543210’ order by phone_number; To retrieve all records not containing the name “sonia” and the phone number ‘9876543210’ from a MySQL table, and order the results by the phone_number field, you can use the following SQL query: sql SELECT * FROM your_table_name WHERE … Read more

mysql> SELECT * FROM tablename WHERE name = “sonia” AND phone_number = ‘9876543210’ To retrieve records containing the name “sonia” and the phone number ‘9876543210’ in MySQL, you can use the SELECT statement with the WHERE clause. Here’s an example query: sql SELECT * FROM your_table_name WHERE name = ‘sonia’ AND phone_number = ‘9876543210’; Make … Read more