1. Why is it so that the given query worked :"select * from (select rownum rnum,a.* from emp a) where rnum=70; "while this query dint work :"select * from (select rownum,a.* from emp a) where rownum=70;"2. as i've read that rownum can work only for < and or >=, then why the query worked for rnum=70
Latest Answer: Hi Frienz...According to me WHERE and HAVING both are equally important..WHERE is used for condition on a single row and it comes before group by clause...whereas HAVING is used with GROUP BY alwayz...HAVING works on a group whereas WHERE works on a single ...
Latest Answer: Self Join-The SELF JOIN is used to join a table to itself, as if the table were two tables, temporarily renaming at least one table in the SQL statement. The syntax is as follows:SELECT A.LAST_NAME, B.LAST_NAME, A.FIRST_NAMEFROM EMPLOYEE_TBL A, ...
Latest Answer: select * from emp where rownum
1. How to delete a duplicate records in a table without using rowid?2. What is the use of Connect by clause?3. What is the use of Connect by clause?4. How to display "Experience of employee"?E.g. 3 years 4 months 19 days?5.What is select statement to spell out SALARY?(Query should work upto 5 million)6. Why output give error message when i write select stmt, ROWNUM=2 in where clause.?7. what is merging?8.How to delete set of records at a time where all the records having same values ,
Using corelated subquery: Inner query results in more than one row/value, then can this values be concatenated as one so that it comes along with outer result test/row as one value.
select * from emp where deptno=any(select deptno from emp having count(deptno)>1 group by deptno);
Latest Answer: select * from acctcycle where acct_nbr in (select acct_nbr from acctcycle group by acct_nbr having count(acct_nbr)>1); ...
Latest Answer: Disadvantages:On primary key index will be created so during updation of table index need to be adjusted accordingly. this process makes the updation slower. ...
Latest Answer: select max(columnname) from tablename where columnname in (select columnname from tablename where columnname
Latest Answer: SELECT TOP 1 salary FROM (SELECT TOP 10 salary FROM employee ORDER BY salary DESC)Â AORDER BY salary ...
View page << Previous 3 4 5 6 [7] 8 9 10 11 12 Next >>
Go Top
