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

Answer Posted / j

select * from emp e where 3=(select count(sal) from emp
where e.sal>sal)

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

-------------How you design DWH?

2056


Explain the difference between native sql and cognos sql?

704


How is cognos model organization works?

780


Diff b/w Crossproduct and Outerjoin?

2024


What is difference between informatica power mart and power center?

757


WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?

6391


------------- How to identify the Revenue Column in Report?

2086


Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

1866


What do you understand by the term 'dynamic cube'?

742


-------------What is Coditional Prompting?

1809


What is looping and how to avoid it in framework manager?

908


How to do Performence Tunning in Cognos Reports?

2247


What is zero-foot print?

782


Can you define drill down and drill up?

828


What is the size of database for you project?

1340