Member Since October 5, 2007 , From Russia
SQL Exercises
Ask
Liked this profile? Tell your friends about it

Recent Activity by Serge_I

Answered: What is DDL and DMl?

DDL - Data Definition Language DML - Data Manipulation Language The both are in SQL. Look in SQL Tutorial : http://www.sql-tutorial.ru

Answered: In access query want create a condition it shows ...

IIf([AMOUNT]<=300000,[AMOUNT]*(1/100),IIf([AMOUNT]>=300000 And [AMOUNT]<=500000,[AMOUNT]*(1.5/100)))

Answered: Help on databases

ORDER BY clause in SELECT statement use for sorting data: http://www.sql-ex.ru/help/select1.php#order_by

Answered: How to write php scripts for displaying tables ...

Use the following query: select table_name from information_schema.tables where table_type='BASE TABLE'

Answered: MySQL database help

Use SUM(points) with grouping by season. http://www.sql-ex.ru/help/select4.php#agregate

Answered: Getting message(the main IDX database file is ...

I suppose that IDX is index file. Try to drop and recreate it. If you can't, simply drop it, maybe the app will make this file by itself.

Answered: Getting message(the main IDX database file is ...

I suppose that IDX is index file. Try to drop and recreate it. If you can't, simply drop it, maybe the app wiil makes this file by itself.

Answered: Creating packages dynamically

To get table names, you can use the following: select table_name from information_schema.tables

Answered: My doubt

Select * from emp where empID=40

Answered: Inserting parameters from keyboard

You can do it in client application using dynamic SQL.

Activity Summary

Topics of Interest

Contacts

Serge_I has no contacts.

Compliments

No compliments were posted on Serge_I's profile yet.