7)
Which is the correct syntax for SELECT statement with TOP keyword to return TOP N records with all columns?
- SELECT * FROM TOP n table_name
- SELECT TOP n * FROM table_name
- SELECT * FROM table_name TOP n
- None of these
Correct Answer - 2
SELECT TOP n * FROM table_name
10)
Which is the correct syntax for INSERT INTO statement without specifying column names?
- INSERT INTO table_name
VALUES( value1, value2, ...)
- INSERT INTO VALUES( value1, value2, ...)
table_name
- INSERT INTO
VALUES( value1, value2, ...) IN table_name
- INSERT * INTO table_name
VALUES( value1, value2, ...)
Correct Answer - 1
INSERT INTO table_name
VALUES( value1, value2, ...)