What are projection and selection

0 votes

What is the difference between projection and selection? Is it:

  • Projection --> for selecting the columns of table; 
  • Selection ---> to select the rows of table?

So are projection and selection vertical and horizontal slicing respectively? 

Sep 10, 2022 in Database by Kithuzzz
• 38,010 points
6,252 views

1 answer to this question.

0 votes

Projection means choosing which columns (or expressions) the query shall return.

Selection means which rows are to be returned.

I hope this helps you.

answered Sep 12, 2022 by narikkadan
• 63,420 points

Related Questions In Database

0 votes
1 answer

What is a Relationship and what are they?

Relation or links are between entities that ...READ MORE

answered Oct 23, 2018 in Database by DataKing99
• 8,240 points
611 views
0 votes
1 answer

What are VDL and SDL?

VDL(View Definition Language): Represents user views and ...READ MORE

answered Nov 13, 2018 in Database by DataKing99
• 8,240 points
9,456 views
0 votes
1 answer

What are the ways of Data Import and Export in MySQL Workbench?

There are majorly three ways to export ...READ MORE

answered Dec 14, 2018 in Database by DataKing99
• 8,240 points
2,049 views
0 votes
1 answer

What are DDL and DML?

SQL Commands have subcategories like DDL, DML, DCL ...READ MORE

answered Feb 8, 2022 in Database by Vaani
• 7,020 points
704 views
0 votes
1 answer

How to connect Java program to the MySQL database?

You can connect your Java code with ...READ MORE

answered May 11, 2018 in Java by Parth
• 4,630 points
1,616 views
0 votes
1 answer

Is SELECT * harmful in Database?

There are really three major reasons: Inefficiency in ...READ MORE

answered Sep 7, 2018 in Database by DataKing99
• 8,240 points
641 views
0 votes
1 answer

Difference between single and double quotes in SQL

Single quotes are used to indicate the ...READ MORE

answered Sep 11, 2018 in Database by CodingByHeart77
• 3,740 points
28,470 views
0 votes
1 answer

Can different databases use different name quotes?

This use of quotes is called delimited ...READ MORE

answered Sep 11, 2018 in Database by CodingByHeart77
• 3,740 points
473 views
0 votes
1 answer
0 votes
1 answer

What does the "@" symbol do in SQL?

The @CustID denotes a parameter for which ...READ MORE

answered Sep 10, 2022 in Database by narikkadan
• 63,420 points
891 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP