• Register
0 votes
159 views

Problem:
Hello Kodlogs,
I am a newbie in the Data Management System. Please check the option below and let me which one is the correct and why?
Thanks.


A.

SELECT <column(s)>
  FROM <Table name>
    BY <Conditions>;

B.

LIST <column(s)>
  FROM <Table name>
    BY <Conditions>;

C.

SELECT <column(s)>
  FROM <Table name>
    WHERE <Conditions>;

D.

LIST <column(s)>
  FROM <Table name>
    BY <Conditions>;

 

6 2
830 points

Please log in or register to answer this question.

1 Answer

1 vote

The correct answer is ‘C’.

Assuming you are using SQL server. SELECT is the most frequently used statement in SQL to retrieve or fetch data from a database. For retrieving specific data you need to choose the Table name using FROM statement and specific condition under the Where statement.

I hope you have got the answer.

5 2
1,480 points

Related questions

0 votes
1 answer 25 views
25 views
Problem: can anyone help me out? I don't know what i have to used to select particle table contents. If any one can know, than answer me.
asked Mar 19 niyatiry 3.9k points
0 votes
1 answer 9 views
9 views
Problem: How to select a partial of a table for exporting using SQL? How can I do that? Thanks
asked Mar 9 ummesalma 29.2k points
0 votes
2 answers 29 views
29 views
Problem: While learning about tables in HTML, I came to know that there are various elements that are used to create a table in HTML and without which our table is incomplete. Can anybody please explain all of those elements to me? Thanks!
asked Mar 5 Code Learner 9.8k points
0 votes
1 answer 7 views
7 views
Question: What is the correct way to change the levels of a factor column in a data.table (note: not data frame) library(data.table) mydt <- data.table(id=1:6, value=as.factor(c("A", "A", "B", "B", "B", "C")), key="id") mydt[, levels(value)] [1] "A" "B" "C" I am looking for something like: mydt[, levels(value) ... 1: 1 A 1: 1 X 2: 2 A 2: 2 X 3: 3 B 3: 3 Y 4: 4 B 4: 4 Y 5: 5 B 5: 5 Y 6: 6 C 6: 6 Z
asked Apr 14 Atik03 26.5k points
0 votes
0 answers 3 views
3 views
Problem: How do I center a div of one column size within the container (12 columns) in Twitter Bootstrap 3?
asked Apr 28 nabin 4.6k points
0 votes
1 answer 2 views
2 views
Problem: What is the easiest way to select data from two tables and rather than join them, have them appear as separate rows? For example I have two tables, one that is shows transactions from one system and another with transactions from a different system. Is there a way to grab all the transactions from both tables as separate rows?
asked Apr 18 anika11 32.2k points
0 votes
1 answer 4 views
4 views
Problem: What is the easiest way to select data from two tables and rather than join them, have them appear as separate rows?
asked Apr 16 anika11 32.2k points
0 votes
1 answer 121 views
121 views
SQL select from multiple tables without join I need to know the easiest way to select data from two tables and have them appear as separate rows. The tables have similar fields and I need to run some functions on them.
asked Nov 24, 2020 miki 1.9k points
0 votes
1 answer 18 views
18 views asked Oct 19, 2020 SapperIt 1.2k points
0 votes
1 answer 3 views
3 views
Problem: Are you know how to add a record to a table click?
asked Apr 13 jamuna1 30.2k points