Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / kishan kumar
select empno,ename,sal,comm,job,mgr,deptno from emp
group by empno,ename,sal,comm,mgr,deptno,rownum
having rownum in (2);
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
The select into statement is most often used to create backup copies of tables or for archiving records?
What is using in sql?
What is trigger point?
How many functions are there in sql?
how tsql statements can be written and submitted to the database engine? : Transact sql
How do you truncate?
How do I sort a table in sql?
What do you mean by stored procedures?
What is field delimiter?
how to load data files into tables with 'mysqlimport'? : Sql dba
Are there any features that are decommissioned in 11g that are not present in 11g?
What is the difference between left and left outer join?
What is the difference between nested table and varray?
what is the use of double ampersand (&&) in sql queries?
Who developed sql?
