Query Syntax

47K

Solutions

11

Articles & Videos

17K

Contributors

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

Refine results

I'm part of a domain with an OU that I administer... I need to create a query for disabled users by user name with a wrm in it..  I have this..
(&(&(|(&(objectCategory=person)(objectSid=*)(!samAccoun…

516 views
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

I'm trying to figure out this query.

If I run:
(CODE)

Then I receive a data set like

group_id
3
119
119
119
3
3
118
3
3
3
3
96
96
96
20
20

So that's what is expected exce…

712 views

I am currently working on a fixed width report for my client. Per the spec's, they need this field to be padded by 0's and the two decimal places are implied.

With that being said, '55.00' should …

312 views

Hello Experts,

I have a SyBase database and when I select the field I get

9/19/2016 4:05:00 PM

I want to return only the the time portion in HH:MM 24 hour format....desired return is: 16:05…

413 views

I'm struggling creating a simple stored procedure within Oracle.  What am I missing from this query?

(CODE)

Basically in my report, I want user to be able to input a transaction date.

1632 views

I would like to combine the columns of two tables, Table1 and Table 2. I used the inner join, but it returned me more rows. I also tried group by the tuple (the 5 columns below) but it still gives me …

1060 views

I am writing query where I need to get the users to has completed at least 3 classes and the last grade received for the third grade should be today's  date.

Here is the query I came up with, but i…

1234 views

I have to produce a fixed width column file for my client. Issue is in this particular section of code.

Let me try to explain this the best way I can. A patient can have a single form of insurance…

527 views

Hi Experts,

I have designed the following query in design view and it worked fine, however when I copy the SQL and try to paste it in new query I get an error "Join expression not supported", what …

1345 views

Hi experts.

I have already created a Visio drawing involving tables/fields that currently match a database.  Each set(s) of tables has a tab.  I could not use reverse engineering so this was done m…

330 views
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Is there a way to run the following SQL statement in Microsoft Access. I have over 1000 row needed to update like this and I can't find a way to do in Access just like I would in MS SQL Management Stu…

919 views

I am trying to convert a datatype char(32) to decimal(5,4) but I know that this field has some values that cannot be converted to a decimal. So I am trying to just ignore those using the following met…

1423 views

Hi, I was using the below query for a refreshable workbook and it suddenly stopped working.. the error when validating it in powerpivot is : "The SQL statement is not valid. There are no columns detec…

1323 views

Hi,

When I put  
OR  J.STATUS='J1'
at the end of the below query I got a performance problem.  As I understood from the EXPLAIN when the select sees the OR at the where section it goes over all t…

415 views

I'm trying to figure out a query to count the IP field and tell me how many of the same IP there are in the table.  

Then I need to delete the duplicates from the table and only leave 1 record for …

733 views

In the query below, if personOne is null, I want to output personTwo as "personOne". Can someone assist? I tried using this but it does't work

(CODE)

1219 views

I am playing around with stored procedures and ran into a problem.  I followed the example and it runs fine with the Command(s) completed successfully.  I open the table and I can't find the record - …

4038 views

Hi Experts,

I'm in middle designing a SQL dynamically by code and need a way to

1- Proper construct the SQL
2- To have it done in a clear manner

here is an extract of the statement.

 …

1423 views

I need to calculate averages miles driven for the car on the day of the week and the overall average. The result need to be displayed on one line. I am using PIVOT table but seems no able to get it to…

1832 views
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Anyone up for a bit of a challenge? I have a query like the one below.

(CODE)
timeIn is a datetime column
timeOut is a datetime column
carType is a string
limitTimeToCheckIn is a number of min…

1313 views

I am working on a Fixed Length Query and need help when the value is NULL. In this section of code below, the Attending Doctors Middle Initial is almost always missing; however, because it is NULL, I …

314 views

hello everyone. i'm sure this can be done and i'm sure i can figure it out with enough time, however i'm asking all you experts out there for a quick reference.

i've got a table, 3 columns: Process…

426 views

Hi Experts,

    I have an MS Access Table MYTable   which has the field MyPath

      The Sample entries in MyPath  (The values corresponding to a  folder structure that  has several subfolders

720 views

I use Access 2010.
I have two tables and I want to delete all records from one table that correspond with the second table.
The select query of the records that I want to delete is:

SELECT TblOrd…

219 views

I have the 3 following Zip Codes in my file

76012
75130-6789
76015-3211

Per the flat file spec's from my client, I have to return 9 characters and not use the hyphen that separates the Left 5 …

217 views
Show more content
201506-LO-Top-001

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. MS Access
    (215,594)
  2. MS SQL Server
    (156,711)
  3. MS SQL Server 2005
    (71,488)
  4. MS SQL Server 2008
    (48,768)
  5. Databases
    (53,501)
  6. MySQL Server
    (46,367)
  7. Oracle Database
    (77,868)
  8. PHP
    (117,296)
  9. ASP
    (80,657)
  10. Visual Basic Classic
    (163,567)