write a query to display to 10 max record from the employee
table?
Answers were Sorted based on User's Feedback
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 |
Answer / srinu
select * from(select rownum r,emp.*from emp order by sal
desc) where r<=10;
Is This Answer Correct ? | 6 Yes | 2 No |
Answer / m m naidu
To display first 10 records we can write the query as
select * from(select * from emp order by ename desc) where
ronum<=10;
Is This Answer Correct ? | 7 Yes | 6 No |
Answer / lakhwinder singh
Query for display the top 10 records from the table(tbl1)
select top 10 * from tbl1
Is This Answer Correct ? | 4 Yes | 3 No |
how many types of variables in cognos report net and cognos 8
Can any one tell me cognos training class in chennai? thanks in advance...
Tell me about Dnamic and Static Dashboards?
What are the best practices while building a Cognos Framework Manager Package ? As in, what calculations would you not like to be handled in FM and rather get it directly from Database.
What is limited local? and the uses?
tell me two or three issues from client side and how to solve those issues?
What is the diff between Drill through reports and Master detail reports?
How to select all in value prompt instead of cascade prompt?
difference between drill through and master detail report?
Define the cognos reporting tool?
----------------What is Surrogate Key?
advantages of detailed filter??? and summarized filter???