answersLogoWhite

0

How do you sort data in a database?

Updated: 8/18/2019
User Avatar

Wiki User

12y ago

Best Answer

To sort is to arrange a field(column) depending on whether you choose to have them from lowest to highest or from highest to lowest (ascending or descending)

User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you sort data in a database?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What software tool can be used to create a database add change and delete data in the database sort and retrieve data and create forms and reports using the data in the database?

datebase management system


What do you need to do before you can sort and filter data in a database?

Before sorting and filtering data in a database, you need to ensure that the data is organized in a tabular format, with each row representing a single record and each column representing a specific attribute. You also need to have a clear understanding of the criteria you will use to sort and filter the data. Finally, you may need to create indexes on the columns you intend to sort or filter for optimal performance.


What does a sort mean in a database?

Sort refers to the action wherein the data fetched from a database table is ordered as per a specific criteria. The default order of sort is Ascending and the user can do a descending sort by using the keyword DESC after the order by keyword. Ex: select * from employee_details order by employee_num desc If the above statement is executed data will be displayed in descending order of employee numbers.


What is the difference between data model and database model?

A database is a collection of tables that is used for some purpose (typically an application of some sort). A database model is a description of that database, and describes how the tables relate to each other. Typically, a model is designed first, then the actual database is implemented using the model as a blueprint.


When would you use a database program?

when i need to see table relationships and sort data by custom fields


What are databse anomalies?

Database anomalies are unmatched or missing information bits caused by limits or flaws within a database. Databases are designed to collect and sort data.


Differentiate DATA from a database?

A database is a collection of data. Data represents items that are stored within the database.


How do you validate and retrieve data from database?

How do you validate and retrieve data from database?" How do you validate and retrieve data from database?"


What is a data type?

Data type, or more commonly datatype as it related to database management systems is the phyisical format by which the data in a database managment is stored on the computers harddrive. The datatypes are database specific. In general, you need to have the same datatype to be able to compare, sort, append data. Data that is not of the same type needs to be CAST or converted to the other datatype before such operations on the data can be performed. Many times this conversion is internal, but in some database management systems, you ned to explicitly convert the data.


How do you open files with DB file extensions?

This is most likely some sort of database, hence the letters DB There are a multitude of database programs, as well as software which stores its data in some sort of database file. The formats vary, though. See the link, below for some of the formats.


Enter on the database or in the database?

We would use in rather than on. Data is stored in a database, not on a database. Data is entered into a database not onto a database.


Why do Database Management is related to MS Access?

Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.