Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

how to sort records in sql?

Answers were Sorted based on User's Feedback

how to sort records in sql?..

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

how to sort records in sql?..

Answer / satish asnani

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

how to sort records in sql?..

Answer / slokh

SELECT * FROM table_name
ORDER BY column_name ASC;

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

what are the demerits of sql?

1 Answers  

Explain spool.

0 Answers  

What are analytic functions in sql?

0 Answers  

How to avoid duplicate records in a query?

0 Answers  

i have some prob lem to tell me about my self in interview first round ...

0 Answers  

what are the advantages of using stored procedures? : Sql dba

0 Answers  

What is on delete restrict?

0 Answers  

Does truncate remove indexes?

0 Answers  

Can a foreign key have a different name?

0 Answers  

Types of cursors and explanation each of them ?

4 Answers   DELL,

where are cookies actually stored on the hard disk? : Sql dba

0 Answers  

When can we use the where clause and the having clause?

0 Answers