Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by cymerman
-
Display results of 3 rows in just 1
if i use just SELECT distinct canc_code1 canc_code FROM m_cancellations UNION ALL SELECT canc_code2 FROM m_cancellations UNION ALL SELECT canc_code3 FROM m_cancellations grOUP BY 1 works. but if i use your complete statement i receive syntax error. can i get the total count on each of the canc...- cymerman
- Post #3
- Forum: Informix solutions
-
Display results of 3 rows in just 1
I have a table with canc_code1 canc_code2 canc_code3. These are cancellation reasons. There is a cancel codes table and a m_cancellations table. cancel code TABLE canc_code canc_desc 01 did not want 02 i do not have money m_cancellations TABLE contract canc_code1 canc_code2 canc_code3 10000...- cymerman
- Thread
- Replies: 2
- Forum: Informix solutions
-
Select info from all databases
Hi All, I have an old version of informix. I do have 8 different databases in the same system. The table structure is all the same across the system. How do I select info from one particular table in all the different databases ? I know that in SQL Server you can do something like: SELECT *...- cymerman
- Thread
- Replies: 1
- Forum: Informix solutions
-
SELECT last 5 rows of a table
Mercury2, There is no RRN. It is an olf informix version and sore procedure is something that i have to learn yet. -
how do I select the last 5 rows in informix
How do I select the last 5 rows of a table ? I have to use "order by" I guess. If this is not possible. How do I select just 5 rows (any rows) of that table ?- cymerman
- Thread
- Replies: 1
- Forum: Informix solutions
-
SELECT last 5 rows of a table
Informix. Sorry if I posted in the worng place. If that is the case, lpease let me know where can I post for informix questions and btw, THANKS for helping. -
SELECT last 5 rows of a table
What if I just want 10 rows of that table ? Any 10 rows. How do I do ? -
SELECT last 5 rows of a table
res_code (resort code) sales_site (resort where the inventory is located) recess_days (recision days) So, for the last row would be SR selling PR the recision days are 10. Sorry for not saying this before -
SELECT last 5 rows of a table
sure can BTW, THANKS A LOT res_code sales_site recess_days SR SR2 10 CL HL 3 CL SR2 3 CL SC2 3 SR SR 10 CL CL 3 LO... -
SELECT last 5 rows of a table
r937, you query is bringing 35 rows. If I use another collumn name that the result is 167 rows. gmmastros, Your query is giving me a sintax error. -
SELECT last 5 rows of a table
How do I select the last 5 rows of a table ? I have to use "order by" I guess. select * from tablename order by col1 asce where last 5 THANKS -
How do I delete the results of a query
Hi All, I have run a query and exported the results from that query to a TXT file. 2503 Rows. Is there any way to write a statement that delets everything that is on this TXT file ? I know the other way which is using the delete blablabla from table where blablabla. But was just wondering if... -
-
-
What am I doing wrong
Thanks for the quick reply. The result of your first query is "no rows found" (the same result as I am getting with mine) and there is a SINTAX error in your second query. Is not your fault, I forgot to mention that i am using an old version of informix. I believe that is the reason. Bottom...
