select top 1 * from (select top 3 * from employee order by employeeid desc

write a query to display the third record from the employee
table?

Question Posted / vsandhyana

Answer Posted / vsandhyana

select top 1 * from (select top 3 * from employee order by
employeeid desc) emp

Thanks
Vsandhyana

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the metric store database?

976

What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?

4397

What is a Query Subject?

1100

What is defined as Cognos Impromptu?

1093

What are the services provided in cognos 8?

1035

What is meant by alternate drill down with ex?

1101

--------------Diff b/w ODS and OLAP?

3212

Can you define metrics designer?

1064

What is a dimension?

1038

Can you define materialized view?

1058

what is hints in cognos and where we use it.

2466

What are various types of gateways in cognos?

1074

how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??

2427

i was asked what are the caluclations done by you in your report? plz give reply

2198

Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder

2770