+ 3

Can SQL replace MS excel?

I'm thinking if all MS excel function can be replicated on SQL

3rd Jun 2017, 1:04 PM
Emmanuel
Emmanuel - avatar
9 odpowiedzi
+ 2
SQL is ANSI standard. so you can access it through web or install a database like Oracle, MS SQL Server or IBM DB2.
3rd Jun 2017, 1:54 PM
Gurpreet Singh
Gurpreet Singh - avatar
+ 2
SQL can replicate all features than MS Excel and much more. SQL is more like MS Access.
3rd Jun 2017, 1:48 PM
Gurpreet Singh
Gurpreet Singh - avatar
+ 2
vlookup and hlookup are similar working with 2 different tables in SQL
3rd Jun 2017, 1:52 PM
Gurpreet Singh
Gurpreet Singh - avatar
+ 2
SQL based applications allows you to handle much larger datasets than excel. Each has its own unique strengths. Excel is more flexible and powerful for presentation and formatting for example. All depends on what you are trying to achieve.
4th Jun 2017, 3:33 AM
Sawj O
+ 1
wow.... I've never understood the functions is MS excel
3rd Jun 2017, 1:51 PM
Emmanuel
Emmanuel - avatar
+ 1
and another thing, does SQL have an app like MS Excel or it is only web based...
3rd Jun 2017, 1:52 PM
Emmanuel
Emmanuel - avatar
+ 1
I've heard of that, but never understood too
3rd Jun 2017, 1:53 PM
Emmanuel
Emmanuel - avatar
+ 1
I see, thanks for the help... but i think i should know both, at least to a reasonable lv before and major on SQL.. i feel MS Excel is more recognised here
3rd Jun 2017, 1:56 PM
Emmanuel
Emmanuel - avatar
+ 1
SQL is a language which is used to work around data. There are many database tools available in market like MySQL, Toad etc which are applications that enable the use of SQL language.
5th Jun 2017, 3:38 PM
megha