How to convert “AS” to relational algebra
up vote
-1
down vote
favorite
If I have a simple query:
SELECT COUNT(*) AS num
FROM Person
GROUP BY ID;
How would I convert this to relational algebra?
sql relational-algebra
add a comment |
up vote
-1
down vote
favorite
If I have a simple query:
SELECT COUNT(*) AS num
FROM Person
GROUP BY ID;
How would I convert this to relational algebra?
sql relational-algebra
2
What do you meanrelational algebra
?
– D-Shih
22 hours ago
I think, You may referAggregation
title of this link : en.wikipedia.org/wiki/Relational_algebra
– Barbaros Özhan
22 hours ago
Hi. There are many relational algebras--Give your texbook name & edition & where in it or define what "relation" means & exactly how the operators work. Define "convert"--Same result? Same structure also? See How to Ask, the downvote arrow mouseover text & hits googling 'stackexchange homework'--What have you found? What can you do? What do you suspect? PS Relation algebra is a programming language. Is there anything more we need to know from a Minimal, Complete, and Verifiable example?
– philipxy
20 hours ago
1
What does your title have to do with the body of your post & your question?
– philipxy
20 hours ago
add a comment |
up vote
-1
down vote
favorite
up vote
-1
down vote
favorite
If I have a simple query:
SELECT COUNT(*) AS num
FROM Person
GROUP BY ID;
How would I convert this to relational algebra?
sql relational-algebra
If I have a simple query:
SELECT COUNT(*) AS num
FROM Person
GROUP BY ID;
How would I convert this to relational algebra?
sql relational-algebra
sql relational-algebra
edited 22 hours ago
D-Shih
23.2k61331
23.2k61331
asked 22 hours ago
Yushey
293
293
2
What do you meanrelational algebra
?
– D-Shih
22 hours ago
I think, You may referAggregation
title of this link : en.wikipedia.org/wiki/Relational_algebra
– Barbaros Özhan
22 hours ago
Hi. There are many relational algebras--Give your texbook name & edition & where in it or define what "relation" means & exactly how the operators work. Define "convert"--Same result? Same structure also? See How to Ask, the downvote arrow mouseover text & hits googling 'stackexchange homework'--What have you found? What can you do? What do you suspect? PS Relation algebra is a programming language. Is there anything more we need to know from a Minimal, Complete, and Verifiable example?
– philipxy
20 hours ago
1
What does your title have to do with the body of your post & your question?
– philipxy
20 hours ago
add a comment |
2
What do you meanrelational algebra
?
– D-Shih
22 hours ago
I think, You may referAggregation
title of this link : en.wikipedia.org/wiki/Relational_algebra
– Barbaros Özhan
22 hours ago
Hi. There are many relational algebras--Give your texbook name & edition & where in it or define what "relation" means & exactly how the operators work. Define "convert"--Same result? Same structure also? See How to Ask, the downvote arrow mouseover text & hits googling 'stackexchange homework'--What have you found? What can you do? What do you suspect? PS Relation algebra is a programming language. Is there anything more we need to know from a Minimal, Complete, and Verifiable example?
– philipxy
20 hours ago
1
What does your title have to do with the body of your post & your question?
– philipxy
20 hours ago
2
2
What do you mean
relational algebra
?– D-Shih
22 hours ago
What do you mean
relational algebra
?– D-Shih
22 hours ago
I think, You may refer
Aggregation
title of this link : en.wikipedia.org/wiki/Relational_algebra– Barbaros Özhan
22 hours ago
I think, You may refer
Aggregation
title of this link : en.wikipedia.org/wiki/Relational_algebra– Barbaros Özhan
22 hours ago
Hi. There are many relational algebras--Give your texbook name & edition & where in it or define what "relation" means & exactly how the operators work. Define "convert"--Same result? Same structure also? See How to Ask, the downvote arrow mouseover text & hits googling 'stackexchange homework'--What have you found? What can you do? What do you suspect? PS Relation algebra is a programming language. Is there anything more we need to know from a Minimal, Complete, and Verifiable example?
– philipxy
20 hours ago
Hi. There are many relational algebras--Give your texbook name & edition & where in it or define what "relation" means & exactly how the operators work. Define "convert"--Same result? Same structure also? See How to Ask, the downvote arrow mouseover text & hits googling 'stackexchange homework'--What have you found? What can you do? What do you suspect? PS Relation algebra is a programming language. Is there anything more we need to know from a Minimal, Complete, and Verifiable example?
– philipxy
20 hours ago
1
1
What does your title have to do with the body of your post & your question?
– philipxy
20 hours ago
What does your title have to do with the body of your post & your question?
– philipxy
20 hours ago
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53235897%2fhow-to-convert-as-to-relational-algebra%23new-answer', 'question_page');
}
);
Post as a guest
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
2
What do you mean
relational algebra
?– D-Shih
22 hours ago
I think, You may refer
Aggregation
title of this link : en.wikipedia.org/wiki/Relational_algebra– Barbaros Özhan
22 hours ago
Hi. There are many relational algebras--Give your texbook name & edition & where in it or define what "relation" means & exactly how the operators work. Define "convert"--Same result? Same structure also? See How to Ask, the downvote arrow mouseover text & hits googling 'stackexchange homework'--What have you found? What can you do? What do you suspect? PS Relation algebra is a programming language. Is there anything more we need to know from a Minimal, Complete, and Verifiable example?
– philipxy
20 hours ago
1
What does your title have to do with the body of your post & your question?
– philipxy
20 hours ago