Is SQL a wender specific language?

More Haseeb Zulfiqar's questions See All

How i can make my own header file in c++?

))

09 October 2011 7,082 5 View

Difference in structure and class in c++?

As all features of them both are same. Using specifiers one can use structure same as class tell some thing new i already know the basic difference that of default specification

09 October 2011 763 18 View

Where to get the compiler for lisp?

and some helpful material on LISP

09 October 2011 5,390 3 View

Which one is the most useful language for artificial intelligence?

I consider of lisp

09 October 2011 5,129 83 View

Which is suitable for use with Python? MySQL or SQL Server?

Which is suitable for use with Python? MySQL or SQL Server? What is your suggestion?

01 March 2021 3,422 3 View

How to plot the probability paper of Gumbel distribution using R programing?

In R-studio, there are many commands of Gumbel package. Arguments are also different. I`m asking about the alpha parameter of the Copula which must be greater than 1. If this is the one used to...

25 February 2021 5,229 3 View

What software programs can directly simulate Additive Manufacturing Directed Energy Deposition (DED)?

I understand there are a lot of software programs that can simulate DED by going through specific modeling, simulation, and commands. For me, that was time consuming and results were not accurate....

24 February 2021 4,428 3 View

I am looking for a simple software program to model 3D chemical bonds. The purpose is to generate high-quality graphical abstracts. Any suggestion?

Hello everyone: I am looking for a simple software program to model chemical bonds. The purpose is to generate a high-quality graphical abstract for a top leading journal in the field of...

23 February 2021 8,012 3 View

How to estimate 2SLS with different instruments for different endogenous variables?

To be specific, I want to conduct an IV regression in stata with the following three equations. EQ1: Y1 ~Y2 Y3 X EQ2: Y2 ~ Z1 EQ3: Y3 ~ Z2 Both Y2 and Y3 are endogenous. However, Z1 and Z2 are...

23 February 2021 6,266 3 View

How to constrain genetic algorithm input u?

My real system (buck converter) can only take an input of 0 to 1 (duty ratio) and I need to constrain the system so the controller action keeps within this bounds. How can I do this? The code for...

22 February 2021 2,125 3 View

Are there packages (R or Python) for simple models (bucket?) to assess soil water content?

Hi everyone. I am researching droguht effects on soil water drought. I am looking for already implemented functions in R or Python to estimate soil water content from precipitation,...

21 February 2021 2,084 1 View

Which is the best software or programming language (user friendly) for analysing data?

I have a basic knowledge on Python, R and MATLAB in analysing data. Among those, which is the best and user friendly? Which one should I learn deeply to analyse data?N:B: I want to learn data...

20 February 2021 3,950 15 View

What is/are the best ML classifier(s) for Sentinel2 images?

Hi I am trying to segment a sentinel2 image. At this stage, I want to run a binary classifier that assigns each pixel to either farm or non-farm pixel. For this purpose, I have 4 10m bands...

15 February 2021 3,596 9 View

What will happen when we assume an upper bound of OFV lower than the global minimum OFV ?

if we assume 20 is the upper bound of an objective function (OF) based on permutation a square matrix (nxn) , The minimum value of the OF=22, then we run a random operator to compute the OF by...

14 February 2021 6,056 5 View

Abhinandan Bhadauria

I guess you mean to say "Vendor", right?

SQL - It's an standard language to query a database and not vendor specific.

Emre Erturk

Dear Haseeb,

Thanks for the question; I currently teach SQL. The general answer is that it is not a vendor specific language. It is well standardized (the latest ISO release is SQL:2011). Having said that, different vendors of database software have implemented small variations or extensions. Therefore SQL code written using one database management system (SQL Server, MySQL, PostgreSQL, and so on) is not always 100% guaranteed to work in another software. database You will sometimes need to make some edits.

Anyway, good luck with SQL,

Emre

Dr. E

Hubert Zarzycki

SQL implementations are incompatible between vendors and do not completely follow standards. Only PostgreSQL is credited for standards compliance. In fact plenty of adjustments are required to make SQL code portable among different database systems. Additionally there are many of procedural extensions such as PL/SQL in Oracle, SQL/PSM in MySQL, SQL PL in IBM DB2. These extensions make the problem even more complicated.