@zamary,
Create table emp1 as select * from emp where 1=2
See, here u are trying to create a new table "emp1" with same structure of what the "emp" table has with no data.
But, as you said ...
Type: Posts; User: ecearund; Keyword(s):
@zamary,
Create table emp1 as select * from emp where 1=2
See, here u are trying to create a new table "emp1" with same structure of what the "emp" table has with no data.
But, as you said ...
Try this..
select empname, salary
from (select empname, salary, dense_rank() over(order by salary) d_rank
from emp)
where d_rank in (3,4,5);
To know about all the commands in unix..
Refer this site Part*II*Section 1: Commands
One more way..
Just hold the Tab key for a while it will asks for possibilities:Say Y
You will get the list...
Hi frnd,
This is some thing like syntax for ur questn...
Grant select on object_name to user_name;
Revoke select on object_name from user_name;
Yes it is possible using analytic functions...
I think this one will help you...
select *
from ( select a.*,
row_number() over ( partition by column1 order by column2) r
...
Yes you can...
Here some examples for u...
1)
UPDATE Table1
SET Table1(col1) = (SELECT Table2(col1)
FROM Table2
WHERE some condition);