Interested to Buy Any Domain ? << Click Here >> for more details...
take one table is t1 and in that column name is f1
f1 column values are
200
5000
3000
7000
300
600
100
400
800
400
i want display the values asc and desc in a single output.
sample output is
f1.a
100
200
300
400
500
600
etc......
and f1.d is
5000
4000
3000
2000
1000
etc...
- 9 Answers
- 12140 Views
- Zensar, I also Faced
- E-Mail Answers
Answer Posted / pooja gupta
select f1.a, f2.d from
(select f1 as a from t order by 1) f1,
(select f1 as d from t order by 1 desc)f2
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
Can you select everything, but 1 or 2 fields, without writer's cramp?
what are null values? : Sql dba
In what condition is it good to disable a trigger?
What is the use of primary key?
how would you get the current date in mysql? : Sql dba
In pl/sql, what is bulk binding, and when/how would it help performance?
What is pl sql commands?
Difference between table function and pipelined function?
How do you use collections in procedure to return the resultset?
How we can update the view?
What are hotfixes and patches?
What is localdb mssqllocaldb?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
how to run 'mysql' commands from a batch file? : Sql dba
discuss about myisam key cache. : Sql dba
