almost 6 years ago
Table Name employee
select * from tablename
Select count (*) from emp where age >40
SELECT empname, age, city FROM emptable ORDER BY empname
SELECT DISTINCT empname FROM emptable
SELECT * FROM people WHERE empname LIKE '%ab%'
select top 5 * from em
select * from emp where job not in ('SALESMAN','CLERK');
select * from emp where ename like'S____';
select * from emp where ename like'%R';
select ename,sal/12 as monthlysal from emp;
Starting with Chrome version 45, NPAPI is no longer supported for Google Chrome. For more information, see Chrome and NPAPI (blog.chromium.org).
Firefox and Microsoft Internet Explorer are recommended browsers for websites using java applets.
Chrome Version Support
Are you sure, you want to delete this comment?
Terms of Service
| © copyright 2020 FindNerd.com. All rights reserved.
Sign up using