SELECT * FROM table_name ORDER BY column

how to sort records in sql?

Question Posted / slokh

Answer Posted / slokh

SELECT * FROM table_name
ORDER BY column_name ASC;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the usage of when clause in trigger?

1032

what is the difference between a web-garden and a web-farm? : Sql dba

1062

how can I make a script that can be bi-language (supports english, german)? : Sql dba

996

What are sql functions? Describe in brief different types of sql functions?

1076

what is the command used to fetch first 5 characters of the string? : Sql dba

1624

How many types of tables are there?

932

Why do we go for stored procedures?

1034

What does (+) mean in sql joins?

1045

differentiate between float and double. : Sql dba

1037

What are aggregate functions in sql?

1139

What is left join in sql?

1040

How can I delete duplicate rows?

994

Can we insert data into view?

890

what are wild cards used in database for pattern matching ? : Sql dba

1125

Write a query to display the current date in sql?

1004