Follow Our FB Page << CircleMedia.in >> 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  






Categories