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 |
Hi..I have COG-112(Report Author),COG-122(Admin),COG-132(Meta data modelling). I took test end of Sep '09.I got 100% wcore with these dumps. If any body need then mail me on kris.bi121@gmail.com
How to configure the Cognos configurations to work in the Windows 2000 Server machine?
what is the meaning of drill down and drill up in COGNOS 8BI
what is dimention?explain dimentable with example?
what is the difference between Cognos EP7 series and Congos8?
What is set to be cardinality?
i would like enter some empty space after every 3 rows how is it possible....?
Hi,please suggest me how to creat username while creating a report.
what is Associated grouping? and how it works in cognos impromptu?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
what is the difference between list report and crosstab report?
How to apply securities for reports in cognos connection?