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
What is a stored procedure in sql with example?
what is a tablespace? : Sql dba
What is cross join example?
how can we know the count/number of elements of an array? : Sql dba
How does sql*loader handles newline characters in a record? : aql loader
What is join view in sql?
What is varchar used for?
what are the 'mysql' command line options? : Sql dba
Mention what does the hierarchical profiler does?
What are primary key and foreign key and how they work?
tell me about various levels of constraint. : Sql dba
What is the difference between clustered and non-clustered indexes?
how to include character strings in sql statements? : Sql dba
How many types of sql are there?
Which one is better sql or oracle?
