Shawn,
Thanks for your help, I was wondering, if you can make any sense out of
WHERE should I insert the TOP Commands, in the snippet below. Although
this code is specific to our application, but maybe you can help me with
this.
Thanks, and I really appreciate your help.
-Kamal.
/* Build the Table Name(s)
Microsoft SQL command -
SELECT iv_sensor_names.name, iv_attack_0.name, iv_alert_type_0.name,
iv_alert_severity_0.name, iv_categories_0.displayableName,
iv_subcategories_0.display_name, iv_detection_0.displayableName,
iv_direction_0.displayableName, iv_result_set_0.displayableName,
iv_alert_0.creationTime
FROM iv_alert iv_alert_0, iv_alert_severity iv_alert_severity_0,
iv_alert_type iv_alert_type_0, iv_attack iv_attack_0, iv_categories
iv_categories_0, iv_detection iv_detection_0, iv_direction
iv_direction_0, iv_result_set iv_result_set_0, iv_sensor_names
iv_sensor_names_0, iv_subcategories iv_subcategories_0
WHERE iv_alert_0.sensorId = iv_sensor_names_0.sensor_id AND
iv_alert_0.alertType = iv_alert_type_0.id AND iv_alert_0.severity =
iv_alert_severity_0.id AND iv_alert_0.attackIdRef = iv_attack_0.id AND
iv_alert_0.categoryId = iv_categories_0.categoryId AND
iv_alert_0.subCategoryId = iv_subcategories_0.idnum AND
iv_alert_0.detectionMechanism = iv_detection_0.detectionMechanism AND
iv_alert_0.resultSetValue = iv_result_set_0.resultSetValue AND
iv_alert_0.direction = iv_direction_0.direction
Table Joins -
iv_alert LEFT JOIN iv_sensor_names ON iv_alert.sensorId =
iv_sensor_names.sensor_id
iv_alert LEFT JOIN iv_alert_type ON iv_alert.alertType =
iv_alert_type.id
iv_alert LEFT JOIN iv_alert_severity ON iv_alert.severity =
iv_alert_severity.id
iv_alert LEFT JOIN iv_attack ON iv_attack.attackIdRef = iv_attack.id
iv_alert LEFT JOIN iv_categories ON iv_alert.categoryId =
iv_categories.categoryId
iv_alert LEFT JOIN iv_subcategories ON iv_alert.subCategoryId =
iv_subcategories.idnum
iv_alert LEFT JOIN iv_detection ON iv_alert.detectionMechanism =
iv_detection.detectionMechanism
iv_alert LEFT JOIN iv_result_set ON iv_alert.resultSetValue =
iv_result_set.resultSetValue
iv_alert LEFT JOIN iv_direction ON iv_alert.direction =
iv_direction.direction
Need LIMIT i_Max_Rows_To_Return
*/
BREAKPOINT()
PRINTF(s_Table, "iv_alert LEFT JOIN iv_sensor_names ON iv_alert.sensorid
= iv_sensor_names.sensor_id ")
APPEND(s_Table: "LEFT JOIN iv_alert_type ON iv_alert.alertType =
iv_alert_type.id ")
APPEND(s_Table: "LEFT JOIN iv_alert_severity ON iv_alert.severity =
iv_alert_severity.id ")
APPEND(s_Table: "LEFT JOIN iv_attack ON iv_alert.attackIdRef =
iv_attack.id ")
APPEND(s_Table: "LEFT JOIN iv_categories ON iv_alert.categoryId =
iv_categories.categoryId ")
APPEND(s_Table: "LEFT JOIN iv_subcategories ON iv_alert.subCategoryId =
iv_subcategories.idnum ")
APPEND(s_Table: "LEFT JOIN iv_detection ON iv_alert.detectionMechanism =
iv_detection.detectionMechanism ")
APPEND(s_Table: "LEFT JOIN iv_result_set ON iv_alert.resultSetValue =
iv_result_set.resultSetValue ")
APPEND(s_Table: "LEFT JOIN iv_direction ON iv_alert.direction =
iv_direction.direction")
/* Build the Where line */
CLEAR(s_Where)
/* Logic goes here for Offset parsing */
PRINTF (s_Where, "WHERE iv_alert.uuid > %d ORDER BY iv_alert.uuid ASC",
i_Offset )
/* Build the Column Names list */
PRINTF(s_Columns0, " iv_alert.uuid, iv_sensor_names.name,
iv_attack.name, iv_alert_type.name, iv_alert_severity.name,
iv_categories.displayableName, " )
PRINTF(s_Columns1, " iv_subcategories.display_name,
iv_detection.displayableName, iv_direction.displayableName,
iv_result_set.displayableName, iv_alert.creationTime, ")
PRINTF(s_Columns2, " iv_alert.targetIPAddr, iv_alert.targetPort,
iv_alert.sourceIPAddr, iv_alert.sourcePort, iv_alert.networkProtocolId
")
PRINTF(s_Columns, "%s%s%s", s_Columns0, s_Columns1, s_Columns2)
BREAKPOINT()
/*
- DO NOT CHANGE THE LINES BELOW -
*/
LOOKUP("SelectDB_CheckStatus","eSecurity_Actions")
SET(i_Record_Counter = 0)
------------------------------------------------------------------------
--------------------
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 28, 2004 2:44 PM
To: Kamal Ahmed
Cc: [EMAIL PROTECTED]
Subject: Re: TOP
In MS SQL Server (T-SQL) you say
SELECT TOP n ........
In MySQL you use:
SELECT .... LIMIT n
(http://dev.mysql.com/doc/mysql/en/SELECT.html)
There is no direct equivalent to SELECT TOP n PERCENT....
Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"Kamal Ahmed" <[EMAIL PROTECTED]> wrote on 07/28/2004
02:39:11 PM:
> Hi,
> Does anyone know how to do a TOP function in MySQL ?
>
> Thanks,
>
> -Kamal.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>
