+ 3
Can SQL replace MS excel?
I'm thinking if all MS excel function can be replicated on SQL
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.
+ 2
SQL can replicate all features than MS Excel and much more.
SQL is more like MS Access.
+ 2
vlookup and hlookup are similar working with 2 different tables in SQL
+ 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.
+ 1
wow.... I've never understood the functions is MS excel
+ 1
and another thing, does SQL have an app like MS Excel or it is only web based...
+ 1
I've heard of that, but never understood too
+ 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
+ 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.