Contents of the BOOKS table

-Which of the following will display the ISBN column of the BOOKS table as the first column in its results?
A) both a and c above
B) SELECT ISBN,title FROM books;
C) SELECT * FROM books;
D) SELECT DISTINCT category,ISBN FROM books;

Question

Contents of the BOOKS table
 
-Which of the following will display the ISBN column of the BOOKS table as the first column in its results?​
A) ​both a and c above 
B) ​SELECT ISBN,title FROM books; 
C) ​SELECT * FROM books; 
D) ​SELECT DISTINCT category,ISBN FROM books;

Quizplus · Accepted Answer

The SELECT statement can be used to specify the order of columns in the results. The ORDER BY clause is used to sort the results in ascending or descending order. The following statement will display the ISBN column as the first column in the results:```SELECT ISBN, title FROM books ORDER BY ISBN;```

Contents of the BOOKS Table