Search the Community
Showing results for tags 'from'.
-
hi, sorry, i have a question to do...but i know how to write in sql query ....however the answer need to write on relational algebra in query is like : SELECT * FROM operation where r='broken' group by pc having count(pc) >1 ; π id,pc,result ( σ r = 'broken' (operation)) like group by and having clasue...i no idea ... i searched on internet still @@ .... isnt the answer like that, i using split/step by step method to do rel 1 = σ r = 'broken' (operation) rel 2 = σ count(pc)>1 γ pc,count(pc) (rel 1)) rel 3 = π id,pc,result (rel 2 ) thanks
- 2 replies
-
- sql
- relational algebra
-
(and 8 more)
Tagged with:
-
Hey ... I want display datetime from DB... EX : 2013-06-10 12:10:5 I want display only year = 2013 MONT = 06 day = 10 how to do like above display the part from datetime. thanks regards