Discussion on:
View:
Show:
I've been reading articles on Builder.com for the last month or so. This is the best one I've read.
Thanks for solving the GROUP BY mystery.
Way to go, ShellyDoll!
Thanks for solving the GROUP BY mystery.
Way to go, ShellyDoll!
I need to make queries with text strings in the WHERE clause, but non-case sensitive, it's given me a really hard time doing so. If you could comment on that...
I had to refer to dozens of books and ask dozens of other programmers about how "GROUP BY" works before I was able to wrap my mind around it. If somebody had described it this way in the first place it would have saved me a lot of *&$&^$ trouble.
I have to say this is the best article I've seen and I have learned much from it; as one other poster noted it was the best writeup of the Group By function I've seen!!
Good Job!
Frank
Good Job!
Frank
This was a nice starting point and sets the stage for creating more complex SQL statements. How about writing a similar article describing how to use calculation in queries, specifically doing a calculation and using its results to feed into other calculations in Group By queries.
Thanks Shelley. The SQL Basics was sharp and precise. I've enjoyed both parts so far.
Aggregate functions and GROUP BY were covered in the first part. Here's the address (or click on the link in this article):
http://builder.com.com/article.jhtml?id=u00320020531dol01.htm
Good luck!
http://builder.com.com/article.jhtml?id=u00320020531dol01.htm
Good luck!
Shelley, I really enjoy your SQL Basics articles. They help me as a beginner and make sense! Keep them coming!
Frank
Frank
If you do not know what the column name is, what is the syntax for a select statement where you specify something like SELECT column1, column2...
?
?
I'm having problems with an SQL statement. The problem calls for a result to display the top 3 employees who have the highest salaries. I'm not sure of how to restrict the rows to display the required rows. I've used the order by clause to sort thevalues by desc, but I can't get just the top 3 from the list. I'm using Oracle Personal Ed. for 98. Any help would be appreciated
I'm not sure about Oracle but this technique definitely works in SQL 7.0 and 2000.
Select TOP 3 * from tblemployees - This will return the top 3 row return based on any where, order by or group by clauses.
Select TOP 3 * from tblemployees - This will return the top 3 row return based on any where, order by or group by clauses.
hello every body...i'm new to SQL.actually i'm in Information security...but need to know some basic sql commands to fetch details in a tool called ArcSight. I want to get the top 10 event counts out of around 40 windows servers.
i have a query that finds events from all the servers in descending order.but i need only 10 top event getters.
Can any one help me with this query.
thanks a lot in advance
i have a query that finds events from all the servers in descending order.but i need only 10 top event getters.
Can any one help me with this query.
thanks a lot in advance
- Keyboard Shortcuts:
- Prev
- Next
- Toggle
