Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the First and Last Observation from the table:
Ex: OBS Name Sal Ans like: OBS Name Sal
105 E 5000--> 105 E 5000
102 B 2000 104 D 4000
103 C 3000
101 A 1000-->
104 D 4000
- 4 Answers
- 6031 Views
- I also Faced
- E-Mail Answers
Answer Posted / ajit
SELECT MIN(Obs)
FROM <Table_name>
UNION ALL
SELECT MAX(Obs)
from <Table_name>;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to get list of all tables from a database?
What is the difference between a query and a report?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
Mention what are different methods to trace the pl/sql code?
Does view contain data?
What does rownum mean in sql?
what is a unique key ? : Sql dba
How can one get sql*loader to commit only at the end of the load file? : aql loader
How to avoid using cursors?
What is pl sql block structure?
Why do we use procedures in sql?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.
What is string join?
how to present a past time in hours, minutes and seconds? : Sql dba
