Assume that the current database has a table with the following structure (the values for the
Field column have been removed for the purpose of this question)
Mysql > DEBS count trylanguage;
How can you select only the first two columns?
A.
SELECT 1, 2 FROM Countrylanguage;
B.
SELECT * FROM Counytrylanguage LIMIT 1, 2,
C.
SELECT *{1,2} FROM Countrylanguage;
D.
SELECT * (1), *[2] FROM Counyrylanguage;
E.
It is not possible without using the column names or without using any other tables or
queries.
E
I think is the A
And that is why you failed
It’s E.
A will only retrieve 2 columns just named 1 and 2.
E
Cannot select column without name.
Why not B?
All are wrong.. You can select the first two columns so E is not true.
SELECT * FROM countrylanguage LIMIT 0,2;
SELECT * FROM countrylanguage LIMIT 2;
This will start from the first row and select 2 rows.
B starts from the second row. Remember that it starts counting from 0.
sorry its E xd