write a query to display to 10 max record from the employee
table?
- 7 Answers
- 12093 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / madhoo
You are question is not clear.....you need decide based on
which column you want first 10 records.....
if you work on Salary column this is the query .......
select distinct sal from emp a
where (select count(*) from emp b where a.sal<b.sal)<=10
order by sal desc
/
Any queries on Sql please feel free to ask me i am very
interest in it......
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is the difference between static and dynamic conditions?
How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
Can you explain a cognos controller?
what is power prompt in cognos ep7series?what is the use of this?
How is cognos model organization works?
How create measures and demensions?
What is defined as Query studio?
what are the features in cognos8ui
---------------Describe OLAP Reporting and RDBMS Reporting?
What is the function of model design accelerator?
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
