Create a table with specified columns Alter the table and add new columns Create another table with help of existing tables Write a query which uses group by clause Write a query which uses having clause

Question

Accepted Answer

Answering SQL related questions on table creation, alteration, and querying with group by and having clauses.

To create a table with specified columns, use the CREATE TABLE statement with column names and data types.
To alter a table and add new columns, use the ALTER TABLE statement with ADD COLUMN keyword.
To create another table with help of existing tables, use the CREATE TABLE statement with SELECT statement.
To write a query which uses group by clause, use the GROUP BY keyword followed by the column name(s) to group the data.
To write a query which uses having clause, use the HAVING keyword followed by a condition to filter the grouped data.

Accepted Answer

It depends you for which project they are selecting. But basic and technically you need to be strong.

Create a table with specified columns Alter the table and add new columns Create another table with help of existing tables Write a query which uses group by clause Write a query which uses having clause

Top PwC Associate interview questions & answers

Popular interview questions of Associate

Top HR questions asked in PwC Associate