Curioustab
Aptitude
General Knowledge
Verbal Reasoning
Computer Science
Interview
Aptitude
General Knowledge
Verbal Reasoning
Computer Science
Interview
Home
»
Interview
»
Technology
How do you display last 5 records in DB2?
Correct Answer:
SELECT * FROM table_name ORDER BY column_name desc Fetch first 5 rows only;
← Previous Question
Next Question→
More Questions from
Technology
Difference between Embeded SQL and Dynamic SQL?
What is DBRM? What it contains? When it will be created?
How does DB2 use multiple table indexes?
What is SPUFI?
What is Mainframe Testing?
What is SQLCA?
What is COPY PENDING status?
What is the difference between Cursor Stability and Repeatable Read isolation levels?
What does it mean if the null indicator has -1, 0, -2?
How can record locking be achieved in those DB2 versions which do not support it?
Discussion & Comments
No comments yet. Be the first to comment!
Name:
Comment:
Post Comment
Join Discussion
Discussion & Comments