Questions tagged [sql]
150 questions
0
votes
2 answers
How to write down SQL query to get the data count of a table?
I have one table named FDR_DATA. There are following fields present in the table. Fields are: B1_NAME, B2_NAME, B3_NAME, ELEMENT, DATUM, WERT. Now I want to query the total number of data in this table and following output will generate.
sql>…
Nainita
- 2,862
0
votes
1 answer
Reading Multi Line SQL in UNIX
Currently, I am reading few queries from the below .sql file
--SOURCE TABLE NAME
--SOURCE QUERY
SEL COL1, COL2, COL3, COL4,
COL5, COL6, COL7 WHERE COL5 = '2015-11-04 16:24:00.000000' FROM SOURCE TABLE;
--TARGET TABLE NAME
--TARGET QUERY…
-1
votes
1 answer
When to use SQL or NoSQL databases?
I am interesting in learning when to use a SQL database, such as MariaDB, and when to use a NoSQL one, such as MongoDB. Is there a specific case where one is preferred over the other?
gacanepa
- 303