Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

how to sort records in sql?

Question Posted / reddyvaraprasadsaimkl

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 field types?

0 Answers  

Is sql low level language?

0 Answers  

Is pl sql different from sql?

0 Answers  

What are the two different parts of the pl/sql packages?

0 Answers  

what is a constraint? : Sql dba

0 Answers  

Can you rollback after commit?

0 Answers  

When should I use nosql database?

0 Answers  

What are the advantages of VIEW?

5 Answers  

what is an alias command? : Sql dba

0 Answers  

What is pl sql and why it is used for?

0 Answers  

What is pl sql variable?

0 Answers  

Mention what plvcmt and plvrb does in pl/sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories