Pergunta de entrevista da empresa V&V Comptech Systems
1. What does Insert Query. 2.What does Delete Query. 3.How to sort the columns. 4.What does inner join in SQL. 5.How to create the Database in SQL
Resposta da entrevista
Sigiloso
29 de abr. de 2024
1.INSERT INTO employees (employee, first_name, last_name, department_id) VALUES (101, 'John', 'Doe', 1); 2.DELETE FROM table_name WHERE condition; 3.SELECT column1, column2, ... FROM table_name ORDER BY column1 [ASC|DESC], column2 [ASC|DESC], ...; 4.SELECT columns FROM table1 INNER JOIN table2 ON table1.column_name = table2.column_name; 5.CREATE DATABASE database_name;