Why do you go for sorting your query results?

SQL SELECT command to fetch data from MySQL table. Whenever you select rows, the MySQL server is free to return them in any order unless you instruct it or else by stating how to sort the result. However you sort a result set by adding

An ORDER BY section that names column or columns you want to sort by.

 

Posted Date: 7/31/2013 2:18:27 AM | Location : United States

Ask an Expert

Related Discussions:- Why do you go for sorting your query results, Assignment Help, Ask Question on Why do you go for sorting your query results, Get Answer, Expert's Help, Why do you go for sorting your query results Discussions

Write discussion on Why do you go for sorting your query results
Your posts are moderated

Write your message here..

Related Questions

Define rule that value of foreign key appear in other table, Determine the ... Determine the rule that a value of a foreign key should appear as a value of some particular table is called a  Ans: Referential constraint.    The rule that a value of a fo

What is called as an n-way merge, What is called as an N-way merge? The... What is called as an N-way merge? The merge operation is a generalization of the two-way merge used by the standard in-memory sort-merge algorithm. It merges N runs, so it is k

Relational database, write on the various type of relationalkey write on the various type of relationalkey

Explain in details about the functions of dba, Explain in details about the... Explain in details about the f unctions of DBA ?

Object-based models - data models, Object-based Models: Use objects as key ... Object-based Models: Use objects as key data representation components . Examples:-   Entity-Relationship Model: It is a collection of real world objects known as entitie

What is middleware, Question: a) What is Client/Server and what benefit... Question: a) What is Client/Server and what benefits can be expected from Client/Server systems? b) Explain what middleware is and what it does. Why would MIS managers be p

Writing a pl/sql program, Problem 1. Create a PL/SQL program to insert ... Problem 1. Create a PL/SQL program to insert data into student table and display the details of the student having Reg.No 1010 Writing a PL/SQL program to Insert data

Explain the outer join, Define Outer join Outer join - If there are any... Define Outer join Outer join - If there are any type of values in the one table that do not have corresponding value(s) in the other, in an equi-join which will not be selected

Explain saving derived attributes to avoid re-computation, Saving Derived A... Saving Derived Attributes to Avoid Re-computation   As discussed, "redundancy means duplication of exact data". But, if multiple copies of same data are present in the system,

Design and implement a database system, Safe Banking is a Canberra based cr... Safe Banking is a Canberra based credit union, which has several branches around Canberra and Queanbeyan. YOU have taken over Safe Banking. YOU need to create a database that organ