245 Answered Questions for the topic SQL

03/27/19

Shapefiles for US city and Zip level?
I already have the information for US states and Counties. I have the information in the JSON files. I want the information for **ALL** US city and Zip Code information. I can't really navigate... more
Follows • 1
Expert Answers •1
Sql

03/27/19

Equivalent of LIMIT and OFFSET for SQL Server?
In PostgreSQL there is the `Limit` and `Offset` keywords which will allow very easy pagination of result sets. What is the equivalent syntax for Sql Server?
Follows • 1
Expert Answers •1

03/26/19

SQL 2012 - How can I convert MultiLineString to Geography?
I have a Geometry LineString that I wish to convert to Geography. Since the Geometry isn't valid , When I use MakeValid on it, SQL convert it to MultiLineString and than the Geography creation is... more
Follows • 1
Expert Answers •1
Sql Php Mysql

03/25/19

Error updating record: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax t
<?phpsession_start();require('connect.php');if(isset($_POST['submit'])){$id = $_POST['id'];$username = $_POST['username'];$name = $_POST['name'];$email = $_POST['email'];$password =... more
Follows • 1
Expert Answers •1
Sql

03/19/19

Inserting multiple rows in a single SQL query?
I have multiple set of data to insert at once, say 4 rows. My table has three columns: `Person`, `Id` and `Office`. INSERT INTO MyTable VALUES ("John", 123, "Lloyds Office"); INSERT INTO... more
Follows • 1
Expert Answers •1
Sql

03/19/19

How to do a FULL OUTER JOIN in MySQL?
I want to do a Full Outer Join in MySQL. Is this possible? Is a Full Outer Join supported by MySQL?
Follows • 1
Expert Answers •1
Sql

03/19/19

Date Format in Reporting Services?
I need to convert this value using expressions in reporting services From 20100804 to Day 04 , Month 08, Year 2010 Is this possible?
Follows • 2
Expert Answers •1
Sql

03/19/19

MySQL select 10 random rows from 600K rows fast?
How can I best write a query that selects 10 rows randomly from a total of 600k?
Follows • 1
Expert Answers •1
Sql

03/19/19

What's the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN?
What's the difference between `INNER JOIN`, `LEFT JOIN`, `RIGHT JOIN` and `FULL JOIN` in ***MySQL***?
Follows • 2
Expert Answers •1
Sql

03/19/19

How do I see what character set a MySQL database / table / column is?
What is the (default) charset for: - MySQL database - MySQL table - MySQL column
Follows • 1
Expert Answers •1
Sql

03/19/19

What is the use of ACID property in database management system?
Follows • 1
Expert Answers •1

03/19/19

Where can I get (USA) county neighbour relationship data?
I need a graph where each node is a US county and each edge represents a border shared between counties. I do not particularly care about the absolute position or shape of each county (though that... more
Follows • 1
Expert Answers •1

03/19/19

Why is a GIS useful?
Follows • 2
Expert Answers •1

03/19/19

Showing Featured Item From the Database?
I have database table as below. id, bungalow_name, type, address, featured A bungalow can be featured in the home page. If a bungalow is featured, `featured` column has the value `1`. I have 50... more
Follows • 1
Expert Answers •1

03/19/19

What are the applications of GIS?
Follows • 2
Expert Answers •1

03/19/19

Calculate vertices' coordinates of a rectangle, given midline and broadth of rectangle?
I have latitude and longitude of two points making the midline of a rectangle. Now I want to determine coordinates of 4 vertices of that rectangle. I know how to calculate on plane geometry by... more
Follows • 1
Expert Answers •1
Sql

03/18/19

Find all tables containing column with specified name - MS SQL Server?
Is it possible to query for table names which contain columns being LIKE '%myName%' ?
Follows • 1
Expert Answers •1
Sql

03/18/19

Best data type for storing currency values in a MySQL database?
What is the best SQL data type for currency values? I'm using MySQL but would prefer a database independent type.
Follows • 1
Expert Answers •1

03/18/19

Swapping column values in Oracle?
I was solving one of the puzzles and came across swapping column values using DML queries: SELECT * FROM TEMP_TABLE; ID1, ID2 -------- 20, 15 20, 15 20, 15 Solution is mathematical... more
Follows • 1
Expert Answers •1

03/18/19

How is Geographic Information system used for Marketing Research?
Follows • 2
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

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

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.