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,000 points
7,603 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,600 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,250 points
760 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,250 points
10,432 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,250 points
2,318 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,070 points
966 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,640 points
1,912 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,250 points
867 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,750 points
29,597 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,750 points
649 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,600 points
1,285 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