answersLogoWhite

0

select name,position,salary

from PERSON

where PERSON.salary <=10000

Find all peoples name job position and salary in the table PERSON where the salary is a meager 10000 or less, then give em a pay rise.

User Avatar

Wiki User

13y ago

What else can I help you with?

Continue Learning about Information Science

What is the fingerprint database called?

I would assume it was a relational database.. I also assume you mean the fingerprint database that is used by the police forces. as far as i am aware it is a relational database. I think because you could query either a name or a fingerprint reading and then get the information relating to it..Example: If you were looking for the name to a set of fingerprints, you would enter the finger print into your query, and then you might get a name if it is in the database, and if you were looking for the fingerprints to a guy, you would enter a name and you might get the fingerprints for him if you have the right name and it is contained within the database.


Difference between database and distributed database?

A database is nothing but simply a collection of records. The data can be stored all at a same place or can be distributed in different systems . When data is stored in different places that is distributed it is called distributed database.A database is normally stored in one place. That could be a physical location, like a particular office. A distributed database is one database that has different parts of it stored in different places. This is often for security and safety purposes. To a user, they still see all of the data they need on their screen, so they don't even realise that it is stored in different locations.


Which are the procedures of database?

Procedures in a database are stored code segments, which can be executed. This is a good way of holding any business logic in a single place. A procedure could be very simple and return the value of the square of two number, or be very complicated, and perform a lot of data validation before inserting data into a table or updating a table for example.


What does it mean to populate a database?

Populating a database generally means adding information (data) to a database, thus filling in any pregenerated information needed. It could also mean adding the fields to a database in order to be able to fill it with information. The final common use of that term is to connect a database to a front end application in order to use the information stored in that database.


Which of the following objects could best be compared to a database?

A library would be the best object to compare to a database. Like a database, a library stores organized information (books) that can be easily accessed and retrieved by users. Additionally, both libraries and databases use classification systems to organize their content for efficient retrieval.

Related Questions

How you could search for data in a database?

i will not tell you :P


How can one learn about database administration?

There are several places where a person can learn about database administration. Someone could search in the library for information about database administrations. Also, someone can search on the computer for sites with information about database administrations.


What is database and its use?

A database is just a bunch of information. A phone/address book would be an example of a database. It's used wherever there's a bunch of information someone wants to keep track of, and to be able to look things up. In a phone/address book data base, you could enter a number and search for a name, or enter a name and search for a number. Or have it sorted after street address, zip code, or whatever items you have entered in the database.


What is an example of how a database can be queried?

In an inventory database, for example, a purchasing query could be done for all merchandise at or near the inventory minimum of the particular item.


What is a manual database?

A manual database example could be a paper telephone book or an old fashioned library card catalog.


What is an example of how one law could explain all motion in the unverse?

Newton's F=ma is an example of a law that could explain all motion in the universe.


Could you please explain in detail with example about inverted terminal repeats?

No.


What could you use a database for?

A database is used to collect data that is related to each other. For example, a database would be necessary if someone's email contact list held more than 100 names and email addresses.


Where can one search for federal trademarks?

In order to look for federal trademarks, a person could use the Trademark Electronic Search System (TESS). This lets the user conduct a search of the database of registered trademarks and pending applications.


Could you check and see if a inmate is in Pee Wee Valley Prison in Kentucky?

Yes. The Kentucky Department of Corrections has an online database where you can search for Kentucky inmates. You can search by inmate name, or you do an advanced search and search for inmates just in a particular facility.


Where can a free public records database be conducted?

I found out when I was a child that I am adopted. Now that I'm an adult, I'd like to find my birth parents. What are some places I could search the free public records database?


Where can you find a listing of an anime with wind in the name?

To date, myanimelist contains perhaps the largest database of anime, so you could search for your anime there.