'MIT','California Institute of Technology','CalTech','IIT') as college_name SELECT college_id, DECODE(college_name,'Massachusetts Institute of Technology', SQL query to illustrate abbreviation of college names based on the available data using DECODE function.
IF college_name = 'Massachusetts Institute of Technology'ĮLSE IF college_name = 'California Institute of Technology' In the above example, we have performed the following IF-THEN-ELSE logic statements and then ordered the entire result set by college_id.
SQL query to categories college fees into affordable and expensive for an Indian student, considering everything above $ 10000 as expensive.ĭECODE(fees,10000,'Affordable','Expensive') In the above example, we have performed the following task using the DECODE function and have then ordered the result set by college_id.ĭECODE function is used to perform procedural IF-THEN-ELSE logic in SQL. The function is a close relative of CASE statements. It is a built-in function in ORACLE / PL SQL database management servers. Here we discuss how DECODE() function works in SQL with query examples for understanding better.RazorSQL is a SQL database query tool, SQL editor, database browser, and administration tool with support for all major databases and built in connection capabilities for DB2, Derby, Firebird, FrontBase, HSQLDB, Informix, Microsoft SQL Server, MySQL, OpenBase, Oracle, PostgreSQL, SimpleDB, SQL Anywhere, SQLite, SQL Azure, and Sybase. Any other JDBC or ODBC (Windows only) compliant database is also supported. RazorSQL ships with a built in relational database engine that is up and running out of the box and requires no end user administration.
0 kommentar(er)
