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?










share|improve this question




















  • 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















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?










share|improve this question




















  • 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













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?










share|improve this question















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






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited 22 hours ago









D-Shih

23.2k61331




23.2k61331










asked 22 hours ago









Yushey

293




293








  • 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














  • 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








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

















active

oldest

votes











Your Answer






StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});














 

draft saved


draft discarded


















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





































active

oldest

votes













active

oldest

votes









active

oldest

votes






active

oldest

votes
















 

draft saved


draft discarded



















































 


draft saved


draft discarded














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




















































































Popular posts from this blog

Bressuire

Vorschmack

Quarantine