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 |
how to load data files into tables with 'mysqlimport'? : Sql dba
what is a view? : Sql dba
Explain the update statement in sql
What is the difference between left join and right join?
Can you rollback after commit?
What are the events on which a database trigger can be based?
What are Lexical Parameters.How They are used in Reports 6i
What does select count (*) mean in sql?
What is the difference between nvl function, ifnull function, and isnull function?
How to display the contents of a current record fetched in a reference cursor?
What is the use of primary key?
How do I add a database to sql?
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)