Answer / ramana

Table Like this

Create Table Employee(Name varchar(20),Location
varchar(20),Salary int)

Query Like this

Select top 1 * from employee where Name not in(select top 1
Name from Employee)

it will display second record....

Answer / madhuparna

select top 1 * from (select top 2 * from employee)A

Answer / prabhat sharma

select top 1 * from xyz where rno > (select top 1 rno from xyz)

rno is a column name and xyz is a table name

Answer / jayaraman b

select min(emp_no) from
(select top 2 * from emp order by emp_no desc)A
--This will give you the 2nd largest Salaried employee

select max(emp_no) from
(select top 2 * from emp order by emp_no desc)A
--This will give you the 1st largest Salaried employee

Answer / ravi

select top 2 from tablename

Differentiate between delete and truncate.

0 Answers  

What are indexes? When do you need to create Indexes?

4 Answers   CarrizalSoft Technologies, HP,

Tell me what is normalization? Explain different forms of normalization?

0 Answers  

Questions on identity?

2 Answers   Infosys,

how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

0 Answers  

If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

1 Answers   Ness Technologies,

Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

2 Answers  

How do I create a stored procedure in sql server?

0 Answers  

Tell me what is fill factor?

0 Answers  

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

0 Answers  

What are “lost updates”?

0 Answers  

How much space does sql server 2016 take?

0 Answers