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

1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format

2 Answers  

How to list all schemas in a database?

0 Answers  

How you would rewrite the sql query to return the customerid sorted numerically?

0 Answers  

What are the different types of replication you can set up in sql server?

0 Answers  

explain what is raid and what are different types of raid configurations? : Sql server database administration

0 Answers  

What is sub-query in sql server?

0 Answers  

What are views in ms sql server?

0 Answers  

What is the use of DBCC commands?

4 Answers   NA,

Define inner join in sql server joins?

0 Answers  

whats the maximum size of view state??

0 Answers  

how many triggers you can have on a table? : Sql server database administration

0 Answers  

what is nonclustered index

0 Answers