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 is the different between unique+not null & primary key,
Why stored procedure is faster than query?
What is the full form of sql?
what are different types of keys in sql?
What is snowflake sql?
How to check if a column is nullable before setting to nullable?
How many tables can a sql database have?
What is the primary key?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
Is oracel sql developer written in java?
What is the benefit of foreign key?
what is commit? : Sql dba
Oracle (3253)
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)