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.
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
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.
K VENKATA SUBBARAO said:
1 decade ago
How can we know the logical process of this query?
Sabari said:
1 decade ago
How can we sort by more than one column at a time?
Avinash said:
1 decade ago
Select * from table name order by col1, col2.
Mayuri said:
1 decade ago
It is column based operation.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers