how to sort records in sql?
Answers were Sorted based on User's Feedback
Answer / hannan oca
by using order by asc or order by des;
we can sort the data.
| Is This Answer Correct ? | 16 Yes | 0 No |
For EMP table
order by deptno asc OR order by deptno desc
Normally records with NULL values are listed at last. We can
change this by using "NULLS FIRST" or "NULLS LAST" along
with order by clause.
Ex: order by deptno nulls first
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / slokh
SELECT * FROM table_name
ORDER BY column_name ASC;
| Is This Answer Correct ? | 1 Yes | 0 No |
What does pragma mean?
What does where 1 1 mean in sql?
What version is sql?
What is a primary key? Explain
Is time a data type in sql?
what are the difference between clustered and a non-clustered index? : Sql dba
What Is a Trigger? How Do You Use It?
Whis is not false in primary key?
what are the advantages of using stored procedures? : Sql dba
How does postgresql compare to oracle/db2/ms sql server/informix?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
Which is better trigger or stored procedure?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)