Techmicra Interview Questions and Answers

Creating a table and inserting values in SQL.

• Use CREATE TABLE statement to create a table.

• Use INSERT INTO statement to insert values into the table.

• Specify column names and data types when creating the table.

• Provide values for each column when inserting data into the table.

To input values in MySQL, use the INSERT INTO statement with the table name and column names.

• Use INSERT INTO statement followed by the table name

• Specify the column names in parentheses after the table name

• Provide the values to be inserted in the corresponding order

Use the GETDATE() function in SQL to find today's date.

• Use the GETDATE() function in SQL to get the current date and time

• To get only the date part, use the CONVERT function with the appropriate style code

• Example: SELECT CONVERT(date, GETDATE()) AS TodayDate;

Rank using window sliding in MySQL

• Use the RANK() function with window sliding to assign ranks to rows based on specified criteria

• Specify the window frame using ORDER BY and PARTITION BY clauses

• Example: SELECT id, name, RANK() OVER (PARTITION BY department ORDER BY salary DESC) AS rank FROM employees

A left join is a type of SQL join that returns all rows from the left table and the matched rows from the right table.

• Left join is used to combine rows from two or more tables based on a related column between them.

• If there is no match found in the right table, NULL values are returned for the columns of the right table.

• Example: SELECT * FROM table1 LEFT JOIN table2 ON table1.id = table2.id;