sangeeta
Answered On : Jun 1st, 2005
we can sort the table by giving asc or desc in order by clause.by default it is desc
eg:select empno,last_name
from emp
order by last_name asc;
Login to rate this answer.
Muhammad Ali
Answered On : Oct 10th, 2005
Correct it. By defualt order is asc not desc.
Login to rate this answer.
manmohan
Answered On : Dec 26th, 2005
no need to write asc because it is by default.
if we want to sort in descending order then we need to specify desc
with the order by command.
Login to rate this answer.
Bhawesh
Answered On : Feb 21st, 2006
in order to sort a table we use ORDER BY Clause.
order by clause has basically 2 options ie: asc,desc.
asc: to sort a table in ascending order.
desc: to sort a table in decending order.
By default a table is sorted in ascending order.
eg: select * from [where ]
orderby <field name1, [field_name2.........]> [asc/desc];
[ ] optional.
Login to rate this answer.
quonos
Answered On : May 1st, 2007
Do you mean Select = Ordering table?
It's a question about creating clustered index on table not ordering "data from table" for me.
Login to rate this answer.
contents or data of the table can be sorted by using clause ORDER BY in SELECT statement.
By default the table is in ASCENDING order.
SYN: SELECT * from [table name]
where [condition]
ORDER BY [column1..] [asc/desc];
1 User has rated as useful.
Login to rate this answer.
Order By is a keyword which is using for sort the table records either ascending or desending.
For eg,
for ascending,
Select emp_name,emp_identity from emp order by emp_identity;
Select emp_name,emp_identity from emp order by emp_identity asc;
for desending,
Select emp_name,emp_identity from emp order by emp_identity desc;
Login to rate this answer.
