Tag: databases

How many rows records the following query will display.. select * from TEMP where rownum between 0 and 3 ? N.R. Temp table has 30 records

How many rows records the following query will display.. select * from TEMP where rownum in (1,3); N.R. Temp table has 30 records

select '1'+'1' from dual ; The o/p would be..

The o/p of the below two queries would be same.. 1.select '1'+1 from dual; 2.select 1+1 from dual;

select dummy from dual ?

select * from dual ?

select dummy from dual minus select * from dual what would be output ?