Domanda di colloquio di 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
Risposta di colloquio
Anonimo
29 apr 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;