Menu
Select Null as Empty from (select * from TblMetaData)
843
1. How do you explain what SQL is to someone without a technical background? SQL or Structured Query Language is a standardized programming language used to access or manipulate data in a database. It was designed to update, add, delete a row of data and retrieve subsets of information within the database.
SQL uses a set of commands to manipulate the data in databases. Examples include SQL INSERT, which is used to add data to database tables; SQL SELECT, which retrieves data from database tables; and SQL UPDATE, which modifies existing database records.
Here's a good example answer: “I feel there can be a real sense of achievement working in SQL, from solving broken queries to designing new ones! There is so much to learn working with SQL, it's an exciting and growing coding language and I want to expand my query design abilities through this role.”
Looks like, it is trying to get null rows for the same number of rows in tblMetaData.
EDIT: This could be written asSELECT Null AS Empty FROM tblMetaData
70
It will yield a result set with one column named Empty which only contains NULL values. The number of rows will be equal to the number of rows available in TblMetaData.
35
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
