Visit Our UNIX and Linux User Community


Good SQL Forum


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Good SQL Forum
# 1  
Old 01-15-2002
Data Good SQL Forum

Hey all,

I'm trying to locate a good sql forum - similar in nature to this, where I can can get some quick responses to questions I have.

I've tried a few but they are either no longer running - or have one visitor every month.... just wanting to see if anyone uses a forum that is of the same calibre as this one....

Or (not particularly appropriate for this forum) if there is a SQL guru in here that can answer a distinct counting question for me....Smilie
# 2  
Old 01-15-2002
here's one i've used, of course it's not as good as this forum!

http://www.tek-tips.com/gthreadminde...ev3/32/pid/220
# 3  
Old 01-15-2002
Alrighty then....I have a table that contains a number of columns.

I want to count the number of instances of each distinct entry in one column.

i.e.

Table has a request_status column - which can have one of 5 states.... approved, rejected, processed ....

I want to count the number of approved and the number of rejected etc. I don't want to do this manually as with 5 it's okay - but I want the syntax for other queries where there are hundreds of states .....
# 4  
Old 01-15-2002
Ooops....checked the reply and all it showed was "here'"

I thought you were saying bring it on..... I already had a look at that forum you have linked...your right it's not that flash.....I'll post but was hoping for a better one......

anyone?
# 5  
Old 01-16-2002
is this what you want;

select count(*),request_status
from table_name
group by request_status

let me know.

- Ed
# 6  
Old 01-16-2002
Yes - Yes -Yes. You can't imagine how long I've looked for that - and it's so simple...easy when you know how I guess....Smilie
# 7  
Old 01-17-2002
I don't know what flavor of SQL that you are using, but the SQL Server listserv is quite active and generally has a pretty good response base.

They are located at http://www.sunbelt-software.com/sql_list_charter.htm.
 

Previous Thread | Next Thread
Test Your Knowledge in Computers #8
Difficulty: Easy
macOS is based on the Unix operating system.
True or False?

8 More Discussions You Might Find Interesting

1. What is on Your Mind?

Mobile: Advanced Forum Statistics to Forum Home Page

For mobile users, I have just added a "first beta" Advanced Forum Statistics to the home page on mobile using CSS overflow:auto; so you can swipe if you need to see more. Google Search Console mobile usability says this page is "mobile friendly" so perhaps this will be useful for some of our... (12 Replies)
Discussion started by: Neo
12 Replies

2. UNIX and Linux Applications

Where to find a good Oracle forum?

Good evening, i need to ask a question to those who have been working with oracle database. I am a newbie in oracle Databases and Ive been looking for any specific oracle forum and i have found hundrends of them. could you recomend a good one from different levels from the basic ones ? i... (2 Replies)
Discussion started by: alexcol
2 Replies

3. Shell Programming and Scripting

Storing multiple sql queries output into variable by running sql command only once

Hi All, I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise. Eg : Select 'Query 1 output' from dual; Select 'Query 2 output' from dual; I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies

4. What is on Your Mind?

Forum Update: Disabled Home Page Forum Statistics for Guests (Not Registered)

Just a quick update; to speed up the forums, I have disabled the forum statistics on the home page for non registered users. No changes for registered users. (0 Replies)
Discussion started by: Neo
0 Replies

5. What is on Your Mind?

This forum is so good it's beyond belief!

This forum has been so instrumental in my learning scripting and unix commands that I seriously can't believe it and have been advertising it to everyone I know. I started from almost zero knowledge and within a few months I already feel much less ignorant. The amount of information and... (7 Replies)
Discussion started by: newbie2010
7 Replies

6. UNIX for Advanced & Expert Users

Call parallel sql scripts from shell and return status when both sql are done

Hi Experts: I have a shell script that's kicked off by cron. Inside this shell script, I need to kick off two or more oracle sql scripts to process different groups of tables. And when both sql scripts are done, I will continue in the shell script to do other things like checking processing... (3 Replies)
Discussion started by: huasheng8
3 Replies

7. AIX

Which Forum for IBM Storage production are good?

Which Forum for IBM Storage production are good? (1 Reply)
Discussion started by: rainbow_bean
1 Replies

8. UNIX for Advanced & Expert Users

Question - Does anyone know a good forum for selling Unix H/ware?

Hi ... apologies for posting in this section ... I figured this would be the best place to pose this question - does anyone know a good forum for selling Unix related hardware - I have a handful of HP C3750's that I would like to sell. I am located in Toronto. Thx. (2 Replies)
Discussion started by: krs1
2 Replies

Featured Tech Videos