answersLogoWhite

0


Best Answer

select count(*) clumns from persons

User Avatar

Wiki User

11y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How can you return the number of records from table?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How can you return all the records from a table named Persons sorted descending by FirstName?

SELECT * FROM Person ORDER BY FirstName DESC


When records are no longer needed what do you do to the table in access?

You "delete the records" from the table.


An access object with which you can enter new records into a table edit existing records in a table or display existing records from a table is a?

The answer would be form.


The total number of records in an opened table is displayed?

between the two sets of navigation buttons


The rows in tables are called in access?

Rows in an Access table are records.Rows in an Access table are records.Rows in an Access table are records.Rows in an Access table are records.Rows in an Access table are records.Rows in an Access table are records.Rows in an Access table are records.Rows in an Access table are records.Rows in an Access table are records.Rows in an Access table are records.Rows in an Access table are records.


How is left join different from normal join?

A left join gets all records from the left linked table. If you have selected columns from the right linked table withouth related records, the columns will be NULL. The normal join gets all records from one table that have related records in a second table.


If a large table contains thousands of records and the application is accessing half of the table which method do you use index searching or full table scan?

Generally, if a select is accessing half of a table it will do a table scan. With thousands of records that should not slow it down much. If you were talking millions of records that might be a different story.


Can you step to the side of the table to return the ball in ping pong?

Yes. You can step to the side of the table to return the ball.


What is rownum and row number?

Rownum is a Oracle variable that can be selected in a query and will return a row value as it was selected from the database table.


In access rows in the table are called?

records


In a 30 record result set if the LIMIT clause is set to LIMIT 2010 how many records will the query return?

The idea here is that the query returns either the number of records which match the query, or the number of records specified in the LIMIT clause - whichever is less. In this case, 30 is less than 2010, so all 30 records will be returned.


The collection of related records called as file or table?

A table is a collection of related records in a database. Each record in a table represents a specific entity or object, and each column in the table represents a specific attribute or characteristic of that entity. Tables are used to organize and store data in a structured and efficient manner.