V&V Comptech Systems interview question
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
Interview Answer
Anonymous
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;