Which clause is used to sort query elements?(a) GROUP(b) GROUP BY(c) ORDER(d) ORDER BYI got this question in a national level competition.The origin of the question is MySQL Setup topic in division General MySQL Use of MySQL

Which clause is used to sort query elements?(a) GROUP(b) GROUP BY(c) O

1.	Which clause is used to sort query elements?(a) GROUP(b) GROUP BY(c) ORDER(d) ORDER BYI got this question in a national level competition.The origin of the question is MySQL Setup topic in division General MySQL Use of MySQL
Answer» Correct ANSWER is (d) ORDER BY The explanation is: An ‘ORDER BY’ clause specifies the sort order. The data is SORTED in ascending order by DEFAULT. To sort in descending order, the keyword DESC is APPENDED to the ‘ORDER BY’ clause. ‘GROUP BY’ is used to group the query RESULTS according to the criteria.

Discussion

No Comment Found

Related InterviewSolutions

In UNIX, the name of the option file is __________(a) .my.cnf(b) .my.ini(c) .my.opt(d) .my.opcThis question was posed to me in semester exam.This intriguing question comes from Interacting with MySQL topic in portion General MySQL Use of MySQL
The connection parameters for setting up MySQL can be stored in an option file to save typing the names every time a connection is established.(a) True(b) FalseI had been asked this question in examination.I'd like to ask this question from Interacting with MySQL in chapter General MySQL Use of MySQL
Which option prints output in table-format when MySQL is run interactively?(a) -t(b) -tf(c) -p(d) -pfThis question was posed to me in semester exam.I want to ask this question from Interacting with MySQL topic in section General MySQL Use of MySQL
To execute the contents of a query file ‘exec.sql’ by feeding it to mysql, which command is used?(a) mysql exec.sql > sampdb(b) mysql sampdb < exec.sql(c) mysql exec.sql(d) mysql execThis question was addressed to me by my school principal while I was bunking the class.I'm obligated to ask this question of Interacting with MySQL in portion General MySQL Use of MySQL
Suppose run_me.sh is a script file. Which command is used to make it executable?(a) chmod +e run_me.sh(b) chmod +a run_me.sh(c) chmod +y run_me.sh(d) chmod +x run_me.shI got this question in an internship interview.This intriguing question comes from Interacting with MySQL topic in chapter General MySQL Use of MySQL
MySQL can be used to execute script files.(a) True(b) FalseI have been asked this question in final exam.This key question is from Interacting with MySQL topic in chapter General MySQL Use of MySQL
On UNIX, statements entered in ‘MySQL’ are saved in which file?(a) .mysql_queries(b) .queries(c) .mysql_history(d) .historyThis question was addressed to me in final exam.This interesting question is from Interacting with MySQL topic in chapter General MySQL Use of MySQL
What does Control-_ do in MySQL input editor?(a) copies to clipboard(b) pastes from clipboard(c) undoes last change(d) deletes the current lineI had been asked this question in a job interview.The question is from Interacting with MySQL topic in chapter General MySQL Use of MySQL
The command to move the cursor to the beginning of line in MySQL input editor is?(a) Ctrl-A(b) Ctrl-E(c) Ctrl-D(d) Esc-aThis question was posed to me by my college director while I was bunking the class.This interesting question is from Interacting with MySQL topic in portion General MySQL Use of MySQL
SHOW DATABASES lists the databases in the server to which you are connected.(a) True(b) FalseThis question was addressed to me during an online interview.My question is from MySQL Setup topic in section General MySQL Use of MySQL

Which clause is used to sort query elements?(a) GROUP(b) GROUP BY(c) ORDER(d) ORDER BYI got this question in a national level competition.The origin of the question is MySQL Setup topic in division General MySQL Use of MySQL

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment