How to get Top 10 Salaries from a Table
Answers were Sorted based on User's Feedback
Answer / abirami
select max(salary) from tablename
fetch first 10 rows only
Is This Answer Correct ? | 4 Yes | 25 No |
wt is view ? wht r the restrictions for view ?
How many buffer pools are available in db2?
What is db2 stogroup?
what is utility for parm lib
Describe major components of db2?
what is main use of table space and index object? please its urgent
5 Answers CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
Where to download IBM DB2 Certification Dumps for the below: C2090-311 : IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 C2090-312 : IBM DB2 11 DBA for z/OS C2090-313 : DB2 11 Application Developer for z/OS C2090-317 : DB2 11 System Administrator for z/OS C2090-541 : DB2 9.7 DBA for Linux UNIX and Windows C2090-543 : DB2 9.7 Application Development C2090-544 : DB2 9.7 Advanced DBA for LUW C2090-545 : DB2 9.7 SQL Procedure Developer C2090-546 : DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade C2090-610 : DB2 10.1 Fundamentals C2090-611 : DB2 10.1 DBA for Linux, UNIX, and Windows C2090-612 : DB2 10 DBA for z/OS C2090-614 : DB2 10.1 Advanced DBA for Linux UNIX and Windows C2090-615 : DB2 10.5 Fundamentals for LUW C2090-617 : DB2 10 System Administrator for z/OS C2090-730 : DB2 9 Family Fundamentals C2090-733 : DB2 9 Application Developer C2090-735 : DB2 9.5 SQL Procedure Developer C2090-737 : DB2 9 System Administrator for z/OS Exam
Can we use select * statement in cobol program without giving field names ???
How to find schema of a table in db2?
What is copy book?