Answer / 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);

Answer / kishore.p

select top 1 * from tblemp b where b.empsal not in(select
top n-1 empsal from tblemp e)

note:- here the n will be the number of only row you would
like to display.

here in the above case n=2 i.e., n-1=1

so this will be the querry:

select top 1 * from tblemp b where b.empsal not in(select
top 1 empsal from tblemp e)

Answer / m

IN Mysql we can do like this,
in that number starts from 0 so first parameter show
after LIMIT is row no. means here second row
and next 1 for limit that how many records do u want
to show. it means 1 record.


SELECT *
FROM `student_info`
LIMIT 1 , 1;

Answer / shince jose

select * from (

select ROW_NUMBER() OVER (ORDER BY alias) as rowid ,alias

from tbl) a where rowid=2.

Answer / rajeev thakur

(select * from emp where rownum<3) minus (select * from emp
where rownum<2);

Answer / amedela chandra sekhar

SQL> select * from (select rownum as rno,emp.* from emp)
2 where rno=&n;
Enter value for n: 2
old 2: where rno=&n
new 2: where rno=2

RNO EMPNO ENAME JOB MGR
HIREDATE SAL
---------- ---------- ---------- --------- ----------
--------- ----------
COMM DEPTNO
---------- ----------
2 7499 ALLEN SALESMAN 7698
20-FEB-81 1600
300 30

Answer / vamsi nukala

select * from(select rownum as rno,emp.* from emp)where rno=2;

Answer / sushma s

select * from emp where rownum<=2
minus
select * from emp where rownum<2

Answer / amit kumar (patna)

select * from
( select rownum rn, job_ticket_mst.* from job_ticket_mst where rownum<=2)
where rn=2

Answer / priya

select * from emp where empno < (select max(empno) from
emp) and rownum<2 order by empno desc

In a Distributed Database System Can we execute two queries simultaneously ? Justify ?

3 Answers  

What is coalesce in sql?

0 Answers  

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance

5 Answers   Target,

What is the Difference between Procedure and Function.Can we call a Function in a DML?

2 Answers   TCS,

Does google use sql?

0 Answers  

table - new_no old_no 2345 1234 3456 2345 5678 4567 output sud be -new_no 1234 2345 3456 4567 5678

2 Answers  

Mention what does the hierarchical profiler does?

0 Answers  

Why do we use partitions in sql?

0 Answers  

What is pl sql quora?

0 Answers  

what are the 'mysql' command line options? : Sql dba

0 Answers  

in procedure how to return a value

3 Answers   Wipro,

What is $$ in sql?

0 Answers