how to sort records in sql?

Answer Posted / slokh

SELECT * FROM table_name
ORDER BY column_name ASC;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are dynamic queries in t-sql? : Transact sql

742


Does pl/sql support create command?

743


Can %notfound return null after a fetch?

756


What are reports usually used for?

761


Write a sql query to convert all character to uppercase after hypen.

1167






What is sql prepared statement?

735


What is lexical units in pl sql?

757


Explain aggregate functions are available there in sql?

752


Why indexing is needed?

726


Is subquery faster than join?

740


What is data definition language?

803


What is primary key and foreign key?

716


how many sql dml commands are supported by 'mysql'? : Sql dba

790


What does bitemporal mean?

761


Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

742