Database - Introduction to SQL - Discussion
Discussion Forum : Introduction to SQL - True or False (Q.No. 6)
6.
The rows of the result relation produced by a SELECT statement can be sorted, but only by one column.
Discussion:
7 comments Page 1 of 1.
Avinash said:
1 decade ago
Select * from table name order by col1, col2.
Mayuri said:
1 decade ago
It is column based operation.
Haii said:
1 decade ago
Does result of select statement get stored?I think it is only the workspace where the results are stored temporarly.
Prema said:
1 decade ago
But if the two records are same means that two records only arrange by s2 not the whole table.
Shanthi said:
1 decade ago
See an example
select names orderby s1,s2;
means it arranges name based on s1.if it get conflict while doing sorting then it uses s2.
suppose we have two records with same s1 then it arranges based on s2
select names orderby s1,s2;
means it arranges name based on s1.if it get conflict while doing sorting then it uses s2.
suppose we have two records with same s1 then it arranges based on s2
Sabari said:
1 decade ago
How can we sort by more than one column at a time?
K VENKATA SUBBARAO said:
1 decade ago
How can we know the logical process of this query?
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers