252 Answered Questions for the topic SQL

03/18/19

Use QuadTree for better complexity on search features?
I want to improve the complexity of search specific feature when using this function : map.forEachFeatureAtPixel(e.pixel, function (feature, layer) { // Do something.. }); The improvment... more
Follows • 1
Expert Answers •1

03/18/19

oracle sql date not later than today?
I need to display some data if it's a - new data - updated data let's say, I will be basing these data from a publishdate column and updated column where publishdate and updateddate are both... more
Follows • 1
Expert Answers •1

03/18/19

Why do geographers use a gird system on maps?
Follows • 1
Expert Answers •1
Sql

03/18/19

What is the difference between single and double quotes in SQL?
What is the difference between single quotes and double quotes in SQL?
Follows • 1
Expert Answers •2
Sql

03/18/19

Rotate a table in reporting services?
Is it possible to rotate a table in reporting services 2008? If so, how? I'd like to rotate it 90 degrees. Thanks
Follows • 1
Expert Answers •1
Sql

03/18/19

What is the difference between Left, Right, Outer and Inner Joins?
I am wondering how to differentiate all these different joins ...
Follows • 1
Expert Answers •2
Sql

03/18/19

How to order by with union?
Is it possible to order when the data is come from many select and union it together.Such as Select id,name,age From Student Where age < 15 Union Select id,name,age From Student ... more
Follows • 1
Expert Answers •2

03/18/19

It it possible to grab SQL tables from a QuickBooks QBM file. Perhaps there is an SQLite Database in there?
It would simplify data import for our software if I could export the tables to SQL or CSV or other workable format. We often export from QuickBooks and import into our software and it would be... more
Follows • 1
Expert Answers •1
Sql

03/18/19

How to use count and group by at the same select statement?
I have an sql select query that has a group by. I want to count all the records after the group by statement. Is there a way for this directly from sql? For example, having a table with users I... more
Follows • 1
Expert Answers •1

03/18/19

Trying to convert geometry to geography keep failing in MSSQL 2012?
In MSSQL I have LineString in Geometry type. When I try to convert it to geography using : ... more
Follows • 1
Expert Answers •1

03/18/19

Needing to find parent zip code of a bunch of missing zip codes in the US?
We're using MapPoint to export zip code / territory combinations. Unfortunately, the export doesn't include PO Box zip codes which mean that we're missing a lot of zip codes The PO Box zip codes... more
Follows • 1
Expert Answers •1
Sql

03/18/19

Favourite performance tuning tricks?
When you have a query or stored procedure that needs performance tuning, what are some of the first things you try?
Follows • 1
Expert Answers •1
Sql

03/16/19

How do I list all the columns in a table?
For the various popular database systems, how do you list all the columns in a table?
Follows • 1
Expert Answers •1
Sql

03/16/19

How can I copy data from one column to another in the same table?
Is it possible to copy data from column A to column B for all records in a table in SQL?
Follows • 1
Expert Answers •3
Sql

03/15/19

What is the fastest way to count the exact number of rows in a very large table?
I have come across articles that state that `SELECT COUNT(*) FROM TABLE_NAME` will be slow when the table has lots of rows and lots of columns. I have a table that might contain even billions of... more
Follows • 1
Expert Answers •1
Sql

03/14/19

How to request a random row in SQL?
How can I request a random row (or as close to truly random as is possible) in pure SQL?
Follows • 1
Expert Answers •1
Sql

03/14/19

SQL multiple column ordering?
I am trying to sort by multiple columns in SQL, and in different directions. `column1` would be sorted descending, and `column2` ascending. How can I do this?
Follows • 1
Expert Answers •1
Sql

03/14/19

I want to use CASE statement to update some records in sql server?
UPDATE dbo.TestStudents SET LASTNAME = ( CASE WHEN (LASTNAME = 'AAA') THEN 'BBB' WHEN (LASTNAME = 'CCC') THEN 'DDD' WHEN (LASTNAME = 'EEE') THEN 'FFF' ELSE (LASTNAME) END... more
Follows • 1
Expert Answers •1

03/13/19

Area between two longitudes?
I am trying to compute the area between two longitudes (using the angle between them) but am having a hard time. I can do that more easily between latitudes but longitude reveals to be... more
Follows • 1
Expert Answers •1
Sql

03/13/19

SQL JOIN and different types of JOINs?
What is a SQL `JOIN` and what are different types?
Follows • 1
Expert Answers •2
Sql

02/18/19

sql error, can you please tell me what I am doing wrong
can you explain what I did wrong I Am trying to make an sql table in Microsoft Access but I am getting a syntax error for create table with the following code:CREATE TABLE SALES_REP (REP_NUM CHAR(... more
Follows • 1
Expert Answers •2
Sql Php Mysql

01/10/19

How do I get the size of a particular table in MySQL database?
Follows • 1
Expert Answers •1

04/14/18

i need help with PL/SQL (Oracle)
Write a complete PL/SQL program that enables a user to interact with a database of your choice (for example you may choose employee database, or student, or a library database, … etc). The database... more
Follows • 1
Expert Answers •2
Sql

03/01/18

Write a query to display the product name and unit price for all the products supplied by the Ma Maison company
use subquery only.
Follows • 1
Expert Answers •3
Sql

12/12/15

List the name of each officer who has reported more than the average number of crimes officers have reported.
NEED THE QUERY
Follows • 2
Expert Answers •3

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.