I have an SQL statement that grabs the grades of different activity types (Homework, Quiz, etc), and if there’s a drop lowest for that type, it drops, else, it remains. The errors are below as well as the SQL Code. Here are the errors I’m getting: Answer Look into analytical functions. (SO questio…
How can I avoid NULLs in my database, while also representing missing data?
In SQL and Relational Theory (C.J. Date, 2009) chapter 4 advocates avoiding duplicate rows, and also to avoid NULL attributes in the data we store. While I have no troubles avoiding duplicate rows, I …
How can SELECT COUNT(*) different from count of all records in the table?
So I have a table: SELECT COUNT(*) returns a different value than SELECT DISTINCT COUNT(*). How can this be possible? I also tried which returned the same count as the distinct query. I can’t see how with a primary key and all fields being NOT NULL, there can be a different total count than the count of…
Need to list all triggers in SQL Server database with table name and table’s schema
I need to list all triggers in SQL Server database with table name and table’s schema. I’m almost there with this: I just need to get the table’s schema also. Answer Here’s one way: EDIT: Commented out join to sysusers for query to work on AdventureWorks2008. EDIT 2: For SQL 2000
What does # mean in sql?
Does anyone know what something like OR 1# means in the context of mysql injection?
SQL: Advantages of an ENUM vs. a one-to-many relationship?
I very rarely see ENUM datatypes used in the wild; a developer almost always just uses a secondary table that looks like this: But the same thing can also be shown using a user-defined type / ENUM: (Example shown using PostgreSQL, but other RDBMS’s have similar syntax) The biggest disadvantage I see to …
Insert Fail because of wrong non-numeric character
hy table: create table Players (PlayerNo number (4) not null, Name varchar2(15), date_of_birth date,leagno varchar(4)); wrong insert: insert into PLAYERS (PlayerNo,Name,date_of_birth,leagno) …
SQL Server: Why do use SMO?
I have been working with SQL Server for a couple of years. I have heard about SMO but I don’t know anything about it. What are the benefits of using it? Should I learn and start using SMO in my SQL …
What’s the best way to join on the same table twice?
This is a little complicated, but I have 2 tables. Let’s say the structure is something like this: *Table1* ID PhoneNumber1 PhoneNumber2 *Table2* PhoneNumber SomeOtherField The tables can be joined …
Get random object from SQL database via Hibernate
I have following MySql dependent code ( ORDER BY RAND() ) . I would like to know if there is hibernate HQL alternative for it (admin is boolean tag indicating that the user as an admin). This is …