answersLogoWhite

0

How do you retrieve records that have no data in SQL?

Updated: 8/20/2019
User Avatar

Junaidkhawaja27

Lvl 1
11y ago

Best Answer

You can write a query to look through specific fiends and check if there is any data in the field as so.

SELECT * FROM table WHERE field1 = '' OR field2 = '' ... and so on

User Avatar

Wiki User

11y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you retrieve records that have no data in SQL?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is a query language that allows users to manage update and retrieve data?

SQL


What is the SQL data base material used for?

The SQL data base is programming language used to manipulate and retrieve data. Included in the language are elements such as data insert, query, update and delete.


What is the name of a statement written to retrieve specific data from a table?

The name of a statement written to retrieve specific data from a table is a SQL SELECT statement.


Which one of the following is the most efficient way to retrieve data from an MS SQL database?

SqlDataReader


How do you retrieve data from table in sql by selecting month?

select * from "table-name" where month="required month";


What is the command to retrieve deleted data from any table in SQL?

rollback command can retrieve deleted data from a table, provided commit has not been performed after deleting the data. both rollback and commit are transaction control statements.


How do you store and retrieve images from ms access or MySQL database using JSP source code required?

Retrieve sql data you may with the help of programming way. You need to software working with sql databases of any version SQL Server. I would recommend you to try tool below.


How do you retrieve data from an SQL database based on the values selected from combo box using jsp?

Try to repair sql database owing to utility below. Software is able to restore sql databases any version of MS SQL Server.


What is the function of Microsoft SQL?

SQL is a relational database management system. The very first function of this software is to keep the data safe and retrieve it When it is asked by other software applications.


What is the SQL Server Express used for?

The SQL Server Express is used to store and retrieve data when requested by other software operations that are running within the same computer or network.


Which SQL command would you use to retrieve a record or records from the database?

SELECT FROM clause Eg: SELECT <select_options> FROM <table_name> [ WHERE <condition> ]


How do abstract data from medical records?

To abstract data from the medical records, simply go to the medical files in question to retrieve the information.